Perfil Clientes Comercio Eletronico

Dataset statistics

Number of variables	37
Number of observations	114073
Missing cells	166253
Missing cells (%)	3.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	32.2 MiB
Average record size in memory	296.0 B

Variable types

Categorical	24
Numeric	13

Warnings

`id_pedido` has a high cardinality: 95128 distinct values	High cardinality
`id_consumidor` has a high cardinality: 95128 distinct values	High cardinality
`horario_pedido` has a high cardinality: 94624 distinct values	High cardinality
`pedido_aprovado` has a high cardinality: 87124 distinct values	High cardinality
`pedido_com_entregador` has a high cardinality: 78920 distinct values	High cardinality
`pedido_entregue` has a high cardinality: 94340 distinct values	High cardinality
`data_estimada` has a high cardinality: 444 distinct values	High cardinality
`produto_id` has a high cardinality: 31625 distinct values	High cardinality
`vendedor_id` has a high cardinality: 2914 distinct values	High cardinality
`data_limite_envio` has a high cardinality: 90127 distinct values	High cardinality
`id_review` has a high cardinality: 94947 distinct values	High cardinality
`titulo_review` has a high cardinality: 4409 distinct values	High cardinality
`comentario_review` has a high cardinality: 34589 distinct values	High cardinality
`data_criacao_review` has a high cardinality: 627 distinct values	High cardinality
`data_resposta_review` has a high cardinality: 94800 distinct values	High cardinality
`categoria_produto` has a high cardinality: 73 distinct values	High cardinality
`id_unico_consumidor` has a high cardinality: 92081 distinct values	High cardinality
`cidade_consumidor` has a high cardinality: 4073 distinct values	High cardinality
`cidade_vendedor` has a high cardinality: 588 distinct values	High cardinality
`titulo_review` has 100406 (88.0%) missing values	Missing
`comentario_review` has 65847 (57.7%) missing values	Missing
`id_pedido` is uniformly distributed	Uniform
`id_consumidor` is uniformly distributed	Uniform
`horario_pedido` is uniformly distributed	Uniform
`pedido_aprovado` is uniformly distributed	Uniform
`pedido_entregue` is uniformly distributed	Uniform
`data_limite_envio` is uniformly distributed	Uniform
`id_review` is uniformly distributed	Uniform
`data_resposta_review` is uniformly distributed	Uniform
`id_unico_consumidor` is uniformly distributed	Uniform

Reproduction

Analysis started	2021-02-26 13:00:43.872584
Analysis finished	2021-02-26 13:01:55.206795
Duration	1 minute and 11.33 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

id_pedido
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	95128
Distinct (%)	83.4%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

895ab968e7bb0d5659d16cd74cd1650c	63
fedcd9f7ccdc8cba3a18defedd1a5547	38
ccf804e764ed5650cd8759557269dc13	26
465c2e1bee4561cb39e0db8c5993aafc	24
a3725dfe487d359b5be08cac48b64ec5	24
Other values (95123)	113898

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3650336
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	82632 ?
Unique (%)	72.4%

Sample

1st row	e481f51cbdc54678b7cc49136f2d6af7
2nd row	e481f51cbdc54678b7cc49136f2d6af7
3rd row	e481f51cbdc54678b7cc49136f2d6af7
4th row	128e10d95713541c87cd1a2e48201934
5th row	0e7e841ddf8f8f2de2bad69267ecfbcf

Value	Count	Frequency (%)
895ab968e7bb0d5659d16cd74cd1650c	63	0.1%
fedcd9f7ccdc8cba3a18defedd1a5547	38	< 0.1%
ccf804e764ed5650cd8759557269dc13	26	< 0.1%
465c2e1bee4561cb39e0db8c5993aafc	24	< 0.1%
a3725dfe487d359b5be08cac48b64ec5	24	< 0.1%
68986e4324f6a21481df4e6e89abcf01	24	< 0.1%
c6492b842ac190db807c15aff21a7dd6	24	< 0.1%
6d58638e32674bebee793a47ac4cbadc	24	< 0.1%
285c2e15bebd4ac83635ccc563dc71f4	22	< 0.1%
5a3b1c29a49756e75f1ef513383c0c12	22	< 0.1%
Other values (95118)	113782	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
895ab968e7bb0d5659d16cd74cd1650c	63	0.1%
fedcd9f7ccdc8cba3a18defedd1a5547	38	< 0.1%
ccf804e764ed5650cd8759557269dc13	26	< 0.1%
465c2e1bee4561cb39e0db8c5993aafc	24	< 0.1%
a3725dfe487d359b5be08cac48b64ec5	24	< 0.1%
68986e4324f6a21481df4e6e89abcf01	24	< 0.1%
c6492b842ac190db807c15aff21a7dd6	24	< 0.1%
6d58638e32674bebee793a47ac4cbadc	24	< 0.1%
285c2e15bebd4ac83635ccc563dc71f4	22	< 0.1%
5a3b1c29a49756e75f1ef513383c0c12	22	< 0.1%
Other values (95118)	113782	99.7%

Most occurring characters

Value	Count	Frequency (%)
b	229322	6.3%
4	229296	6.3%
6	229120	6.3%
e	228858	6.3%
3	228453	6.3%
c	228324	6.3%
7	228282	6.3%
1	228182	6.3%
a	228179	6.3%
8	228133	6.2%
Other values (6)	1364187	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2280671	62.5%
Lowercase Letter	1369665	37.5%

Most frequent character per category

Value	Count	Frequency (%)
4	229296	10.1%
6	229120	10.0%
3	228453	10.0%
7	228282	10.0%
1	228182	10.0%
8	228133	10.0%
2	227750	10.0%
9	227476	10.0%
0	227102	10.0%
5	226877	9.9%

Value	Count	Frequency (%)
b	229322	16.7%
e	228858	16.7%
c	228324	16.7%
a	228179	16.7%
f	227940	16.6%
d	227042	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2280671	62.5%
Latin	1369665	37.5%

Most frequent character per script

Value	Count	Frequency (%)
4	229296	10.1%
6	229120	10.0%
3	228453	10.0%
7	228282	10.0%
1	228182	10.0%
8	228133	10.0%
2	227750	10.0%
9	227476	10.0%
0	227102	10.0%
5	226877	9.9%

Value	Count	Frequency (%)
b	229322	16.7%
e	228858	16.7%
c	228324	16.7%
a	228179	16.7%
f	227940	16.6%
d	227042	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3650336	100.0%

Most frequent character per block

Value	Count	Frequency (%)
b	229322	6.3%
4	229296	6.3%
6	229120	6.3%
e	228858	6.3%
3	228453	6.3%
c	228324	6.3%
7	228282	6.3%
1	228182	6.3%
a	228179	6.3%
8	228133	6.2%
Other values (6)	1364187	37.4%

id_consumidor
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	95128
Distinct (%)	83.4%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

270c23a11d024a44c896d1894b261a83	63
13aa59158da63ba0e93ec6ac2c07aacb	38
92cd3ec6e2d643d4ebd0e3d6238f69e2	26
63b964e79dee32a3587651701a2b8dbf	24
86cc80fef09f7f39df4b0dbce48e81cb	24
Other values (95123)	113898

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3650336
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	82632 ?
Unique (%)	72.4%

Sample

1st row	9ef432eb6251297304e76186b10a928d
2nd row	9ef432eb6251297304e76186b10a928d
3rd row	9ef432eb6251297304e76186b10a928d
4th row	a20e8105f23924cd00833fd87daa0831
5th row	26c7ac168e1433912a51b924fbd34d34

Value	Count	Frequency (%)
270c23a11d024a44c896d1894b261a83	63	0.1%
13aa59158da63ba0e93ec6ac2c07aacb	38	< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e2	26	< 0.1%
63b964e79dee32a3587651701a2b8dbf	24	< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb	24	< 0.1%
2ba91e12e5e4c9f56b82b86d9031d329	24	< 0.1%
d22f25a9fadfb1abbc2e29395b1239f4	24	< 0.1%
6ee2f17e3b6c33d6a9557f280edd2925	24	< 0.1%
b246eeed30b362c09d867b9e598bee51	22	< 0.1%
be1c4e52bb71e0c54b11a26b8e8d59f2	22	< 0.1%
Other values (95118)	113782	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
270c23a11d024a44c896d1894b261a83	63	0.1%
13aa59158da63ba0e93ec6ac2c07aacb	38	< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e2	26	< 0.1%
63b964e79dee32a3587651701a2b8dbf	24	< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb	24	< 0.1%
2ba91e12e5e4c9f56b82b86d9031d329	24	< 0.1%
d22f25a9fadfb1abbc2e29395b1239f4	24	< 0.1%
6ee2f17e3b6c33d6a9557f280edd2925	24	< 0.1%
b246eeed30b362c09d867b9e598bee51	22	< 0.1%
be1c4e52bb71e0c54b11a26b8e8d59f2	22	< 0.1%
Other values (95118)	113782	99.7%

Most occurring characters

Value	Count	Frequency (%)
2	228874	6.3%
f	228638	6.3%
5	228597	6.3%
c	228587	6.3%
6	228576	6.3%
1	228330	6.3%
d	228207	6.3%
8	228178	6.3%
a	228173	6.3%
e	228108	6.2%
Other values (6)	1366068	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2280573	62.5%
Lowercase Letter	1369763	37.5%

Most frequent character per category

Value	Count	Frequency (%)
2	228874	10.0%
5	228597	10.0%
6	228576	10.0%
1	228330	10.0%
8	228178	10.0%
7	228055	10.0%
9	228023	10.0%
3	227945	10.0%
4	227063	10.0%
0	226932	10.0%

Value	Count	Frequency (%)
f	228638	16.7%
c	228587	16.7%
d	228207	16.7%
a	228173	16.7%
e	228108	16.7%
b	228050	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2280573	62.5%
Latin	1369763	37.5%

Most frequent character per script

Value	Count	Frequency (%)
2	228874	10.0%
5	228597	10.0%
6	228576	10.0%
1	228330	10.0%
8	228178	10.0%
7	228055	10.0%
9	228023	10.0%
3	227945	10.0%
4	227063	10.0%
0	226932	10.0%

Value	Count	Frequency (%)
f	228638	16.7%
c	228587	16.7%
d	228207	16.7%
a	228173	16.7%
e	228108	16.7%
b	228050	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3650336	100.0%

Most frequent character per block

Value	Count	Frequency (%)
2	228874	6.3%
f	228638	6.3%
5	228597	6.3%
c	228587	6.3%
6	228576	6.3%
1	228330	6.3%
d	228207	6.3%
8	228178	6.3%
a	228173	6.3%
e	228108	6.2%
Other values (6)	1366068	37.4%

status_da_ordem
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

delivered	114066
canceled	7

Length

Max length	9
Median length	9
Mean length	8.999938636
Min length	8

Characters and Unicode

Total characters	1026650
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	delivered
2nd row	delivered
3rd row	delivered
4th row	delivered
5th row	delivered

Value	Count	Frequency (%)
delivered	114066	> 99.9%
canceled	7	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
delivered	114066	> 99.9%
canceled	7	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	342212	33.3%
d	228139	22.2%
l	114073	11.1%
i	114066	11.1%
v	114066	11.1%
r	114066	11.1%
c	14	< 0.1%
a	7	< 0.1%
n	7	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1026650	100.0%

Most frequent character per category

Value	Count	Frequency (%)
e	342212	33.3%
d	228139	22.2%
l	114073	11.1%
i	114066	11.1%
v	114066	11.1%
r	114066	11.1%
c	14	< 0.1%
a	7	< 0.1%
n	7	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1026650	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	342212	33.3%
d	228139	22.2%
l	114073	11.1%
i	114066	11.1%
v	114066	11.1%
r	114066	11.1%
c	14	< 0.1%
a	7	< 0.1%
n	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1026650	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	342212	33.3%
d	228139	22.2%
l	114073	11.1%
i	114066	11.1%
v	114066	11.1%
r	114066	11.1%
c	14	< 0.1%
a	7	< 0.1%
n	7	< 0.1%

horario_pedido
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	94624
Distinct (%)	83.0%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

2017-08-08 20:26:31	63
2017-09-23 14:56:45	38
2017-06-07 12:05:10	26
2018-02-14 16:34:27	24
2017-11-25 13:54:39	24
Other values (94619)	113898

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2167387
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	81889 ?
Unique (%)	71.8%

Sample

1st row	2017-10-02 10:56:33
2nd row	2017-10-02 10:56:33
3rd row	2017-10-02 10:56:33
4th row	2017-08-15 18:29:31
5th row	2017-08-02 18:24:47

Value	Count	Frequency (%)
2017-08-08 20:26:31	63	0.1%
2017-09-23 14:56:45	38	< 0.1%
2017-06-07 12:05:10	26	< 0.1%
2018-02-14 16:34:27	24	< 0.1%
2017-11-25 13:54:39	24	< 0.1%
2017-07-07 14:55:43	24	< 0.1%
2018-05-12 12:28:58	24	< 0.1%
2017-03-09 23:39:26	24	< 0.1%
2017-10-17 13:06:29	22	< 0.1%
2017-12-08 12:00:04	22	< 0.1%
Other values (94614)	113782	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-24	1389	0.6%
2017-11-25	620	0.3%
2017-11-27	493	0.2%
2017-11-26	470	0.2%
2017-11-28	438	0.2%
2018-05-15	435	0.2%
2018-08-06	434	0.2%
2018-08-07	422	0.2%
2018-05-07	416	0.2%
2018-05-16	414	0.2%
Other values (50475)	222615	97.6%

Most occurring characters

Value	Count	Frequency (%)
1	352634	16.3%
0	351078	16.2%
2	278326	12.8%
-	228146	10.5%
:	228146	10.5%
8	118856	5.5%
	114073	5.3%
7	105751	4.9%
3	100713	4.6%
5	92165	4.3%
Other values (3)	197499	9.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1597022	73.7%
Dash Punctuation	228146	10.5%
Other Punctuation	228146	10.5%
Space Separator	114073	5.3%

Most frequent character per category

Value	Count	Frequency (%)
1	352634	22.1%
0	351078	22.0%
2	278326	17.4%
8	118856	7.4%
7	105751	6.6%
3	100713	6.3%
5	92165	5.8%
4	92068	5.8%
6	54373	3.4%
9	51058	3.2%

Value	Count	Frequency (%)
-	228146	100.0%

Value	Count	Frequency (%)
	114073	100.0%

Value	Count	Frequency (%)
:	228146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2167387	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	352634	16.3%
0	351078	16.2%
2	278326	12.8%
-	228146	10.5%
:	228146	10.5%
8	118856	5.5%
	114073	5.3%
7	105751	4.9%
3	100713	4.6%
5	92165	4.3%
Other values (3)	197499	9.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2167387	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	352634	16.3%
0	351078	16.2%
2	278326	12.8%
-	228146	10.5%
:	228146	10.5%
8	118856	5.5%
	114073	5.3%
7	105751	4.9%
3	100713	4.6%
5	92165	4.3%
Other values (3)	197499	9.1%

pedido_aprovado
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	87124
Distinct (%)	76.4%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

2017-08-08 20:43:31	63
2017-09-25 17:44:41	38
2017-06-09 16:15:08	26
2017-11-25 14:16:34	24
2018-02-21 12:28:15	24
Other values (87119)	113898

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2167387
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	69811 ?
Unique (%)	61.2%

Sample

1st row	2017-10-02 11:07:15
2nd row	2017-10-02 11:07:15
3rd row	2017-10-02 11:07:15
4th row	2017-08-15 20:05:16
5th row	2017-08-02 18:43:15

Value	Count	Frequency (%)
2017-08-08 20:43:31	63	0.1%
2017-09-25 17:44:41	38	< 0.1%
2017-06-09 16:15:08	26	< 0.1%
2017-11-25 14:16:34	24	< 0.1%
2018-02-21 12:28:15	24	< 0.1%
2017-07-07 15:10:17	24	< 0.1%
2017-03-09 23:39:26	24	< 0.1%
2018-05-12 15:41:58	24	< 0.1%
2018-02-24 03:20:27	23	< 0.1%
2017-10-18 13:06:21	22	< 0.1%
Other values (87114)	113781	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-04-24	1144	0.5%
2017-11-24	964	0.4%
2017-11-25	909	0.4%
2018-07-05	812	0.4%
2017-11-28	587	0.3%
2018-08-07	487	0.2%
2018-05-08	484	0.2%
2018-08-20	483	0.2%
2018-05-01	477	0.2%
2018-05-15	467	0.2%
Other values (41481)	221332	97.0%

Most occurring characters

Value	Count	Frequency (%)
0	365589	16.9%
1	350764	16.2%
2	277141	12.8%
-	228146	10.5%
:	228146	10.5%
	114073	5.3%
8	113012	5.2%
5	110005	5.1%
3	106908	4.9%
7	100945	4.7%
Other values (3)	172658	8.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1597022	73.7%
Dash Punctuation	228146	10.5%
Other Punctuation	228146	10.5%
Space Separator	114073	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	365589	22.9%
1	350764	22.0%
2	277141	17.4%
8	113012	7.1%
5	110005	6.9%
3	106908	6.7%
7	100945	6.3%
4	79109	5.0%
6	49315	3.1%
9	44234	2.8%

Value	Count	Frequency (%)
-	228146	100.0%

Value	Count	Frequency (%)
	114073	100.0%

Value	Count	Frequency (%)
:	228146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2167387	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	365589	16.9%
1	350764	16.2%
2	277141	12.8%
-	228146	10.5%
:	228146	10.5%
	114073	5.3%
8	113012	5.2%
5	110005	5.1%
3	106908	4.9%
7	100945	4.7%
Other values (3)	172658	8.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2167387	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	365589	16.9%
1	350764	16.2%
2	277141	12.8%
-	228146	10.5%
:	228146	10.5%
	114073	5.3%
8	113012	5.2%
5	110005	5.1%
3	106908	4.9%
7	100945	4.7%
Other values (3)	172658	8.0%

pedido_com_entregador
Categorical

HIGH CARDINALITY

Distinct	78920
Distinct (%)	69.2%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

2017-08-10 11:58:14	63
2018-05-09 15:48:00	48
2017-10-02 23:47:54	38
2018-05-10 18:29:00	36
2018-05-14 14:25:00	32
Other values (78915)	113856

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2167387
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	59772 ?
Unique (%)	52.4%

Sample

1st row	2017-10-04 19:55:00
2nd row	2017-10-04 19:55:00
3rd row	2017-10-04 19:55:00
4th row	2017-08-17 15:28:33
5th row	2017-08-04 17:35:43

Value	Count	Frequency (%)
2017-08-10 11:58:14	63	0.1%
2018-05-09 15:48:00	48	< 0.1%
2017-10-02 23:47:54	38	< 0.1%
2018-05-10 18:29:00	36	< 0.1%
2018-05-14 14:25:00	32	< 0.1%
2018-05-04 15:46:00	29	< 0.1%
2018-08-08 15:01:00	27	< 0.1%
2017-06-16 15:50:28	26	< 0.1%
2017-03-15 11:16:33	24	< 0.1%
2018-06-13 14:13:00	24	< 0.1%
Other values (78910)	113726	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-28	909	0.4%
2017-11-27	791	0.3%
2017-11-29	693	0.3%
2018-02-27	613	0.3%
2018-03-27	610	0.3%
2018-08-06	588	0.3%
2017-11-30	569	0.2%
2018-05-14	561	0.2%
2018-08-13	543	0.2%
2018-05-03	529	0.2%
Other values (36935)	221740	97.2%

Most occurring characters

Value	Count	Frequency (%)
0	395677	18.3%
1	337889	15.6%
2	268474	12.4%
-	228146	10.5%
:	228146	10.5%
8	120610	5.6%
	114073	5.3%
7	103767	4.8%
3	95838	4.4%
4	89488	4.1%
Other values (3)	185279	8.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1597022	73.7%
Dash Punctuation	228146	10.5%
Other Punctuation	228146	10.5%
Space Separator	114073	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	395677	24.8%
1	337889	21.2%
2	268474	16.8%
8	120610	7.6%
7	103767	6.5%
3	95838	6.0%
4	89488	5.6%
5	87569	5.5%
6	50224	3.1%
9	47486	3.0%

Value	Count	Frequency (%)
-	228146	100.0%

Value	Count	Frequency (%)
	114073	100.0%

Value	Count	Frequency (%)
:	228146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2167387	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	395677	18.3%
1	337889	15.6%
2	268474	12.4%
-	228146	10.5%
:	228146	10.5%
8	120610	5.6%
	114073	5.3%
7	103767	4.8%
3	95838	4.4%
4	89488	4.1%
Other values (3)	185279	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2167387	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	395677	18.3%
1	337889	15.6%
2	268474	12.4%
-	228146	10.5%
:	228146	10.5%
8	120610	5.6%
	114073	5.3%
7	103767	4.8%
3	95838	4.4%
4	89488	4.1%
Other values (3)	185279	8.5%

pedido_entregue
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	94340
Distinct (%)	82.7%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

2017-08-14 12:46:18	63
2017-10-18 22:35:50	38
2017-06-22 16:04:46	26
2018-02-28 20:09:19	24
2017-11-30 14:59:18	24
Other values (94335)	113898

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2167387
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	81262 ?
Unique (%)	71.2%

Sample

1st row	2017-10-10 21:25:13
2nd row	2017-10-10 21:25:13
3rd row	2017-10-10 21:25:13
4th row	2017-08-18 14:44:43
5th row	2017-08-07 18:30:01

Value	Count	Frequency (%)
2017-08-14 12:46:18	63	0.1%
2017-10-18 22:35:50	38	< 0.1%
2017-06-22 16:04:46	26	< 0.1%
2018-02-28 20:09:19	24	< 0.1%
2017-11-30 14:59:18	24	< 0.1%
2017-03-21 13:32:45	24	< 0.1%
2017-07-27 20:52:15	24	< 0.1%
2018-06-01 15:18:45	24	< 0.1%
2017-10-22 14:43:54	22	< 0.1%
2017-12-21 16:33:10	22	< 0.1%
Other values (94330)	113782	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-05-14	527	0.2%
2018-05-21	526	0.2%
2018-08-13	505	0.2%
2018-05-18	503	0.2%
2018-08-27	501	0.2%
2018-05-03	499	0.2%
2018-04-11	487	0.2%
2017-12-11	482	0.2%
2018-08-23	479	0.2%
2018-04-30	479	0.2%
Other values (41437)	223158	97.8%

Most occurring characters

Value	Count	Frequency (%)
1	335148	15.5%
0	331892	15.3%
2	286993	13.2%
-	228146	10.5%
:	228146	10.5%
8	133871	6.2%
	114073	5.3%
7	105557	4.9%
3	105443	4.9%
4	98848	4.6%
Other values (3)	199270	9.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1597022	73.7%
Dash Punctuation	228146	10.5%
Other Punctuation	228146	10.5%
Space Separator	114073	5.3%

Most frequent character per category

Value	Count	Frequency (%)
1	335148	21.0%
0	331892	20.8%
2	286993	18.0%
8	133871	8.4%
7	105557	6.6%
3	105443	6.6%
4	98848	6.2%
5	92409	5.8%
6	57714	3.6%
9	49147	3.1%

Value	Count	Frequency (%)
-	228146	100.0%

Value	Count	Frequency (%)
	114073	100.0%

Value	Count	Frequency (%)
:	228146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2167387	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	335148	15.5%
0	331892	15.3%
2	286993	13.2%
-	228146	10.5%
:	228146	10.5%
8	133871	6.2%
	114073	5.3%
7	105557	4.9%
3	105443	4.9%
4	98848	4.6%
Other values (3)	199270	9.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2167387	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	335148	15.5%
0	331892	15.3%
2	286993	13.2%
-	228146	10.5%
:	228146	10.5%
8	133871	6.2%
	114073	5.3%
7	105557	4.9%
3	105443	4.9%
4	98848	4.6%
Other values (3)	199270	9.2%

data_estimada
Categorical

HIGH CARDINALITY

Distinct	444
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

2017-12-20 00:00:00	644
2018-03-12 00:00:00	597
2018-05-29 00:00:00	591
2018-07-16 00:00:00	584
2018-03-13 00:00:00	582
Other values (439)	111075

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2167387
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15 ?
Unique (%)	< 0.1%

Sample

1st row	2017-10-18 00:00:00
2nd row	2017-10-18 00:00:00
3rd row	2017-10-18 00:00:00
4th row	2017-08-28 00:00:00
5th row	2017-08-15 00:00:00

Value	Count	Frequency (%)
2017-12-20 00:00:00	644	0.6%
2018-03-12 00:00:00	597	0.5%
2018-05-29 00:00:00	591	0.5%
2018-07-16 00:00:00	584	0.5%
2018-03-13 00:00:00	582	0.5%
2018-07-05 00:00:00	578	0.5%
2018-05-30 00:00:00	578	0.5%
2018-02-14 00:00:00	573	0.5%
2018-05-28 00:00:00	570	0.5%
2018-07-18 00:00:00	569	0.5%
Other values (434)	108207	94.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	114073	50.0%
2017-12-20	644	0.3%
2018-03-12	597	0.3%
2018-05-29	591	0.3%
2018-07-16	584	0.3%
2018-03-13	582	0.3%
2018-05-30	578	0.3%
2018-07-05	578	0.3%
2018-02-14	573	0.3%
2018-05-28	570	0.2%
Other values (435)	108776	47.7%

Most occurring characters

Value	Count	Frequency (%)
0	943524	43.5%
-	228146	10.5%
:	228146	10.5%
1	195288	9.0%
2	177800	8.2%
	114073	5.3%
8	94804	4.4%
7	69340	3.2%
3	30465	1.4%
5	23446	1.1%
Other values (3)	62355	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1597022	73.7%
Dash Punctuation	228146	10.5%
Other Punctuation	228146	10.5%
Space Separator	114073	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	943524	59.1%
1	195288	12.2%
2	177800	11.1%
8	94804	5.9%
7	69340	4.3%
3	30465	1.9%
5	23446	1.5%
6	22197	1.4%
4	21259	1.3%
9	18899	1.2%

Value	Count	Frequency (%)
-	228146	100.0%

Value	Count	Frequency (%)
	114073	100.0%

Value	Count	Frequency (%)
:	228146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2167387	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	943524	43.5%
-	228146	10.5%
:	228146	10.5%
1	195288	9.0%
2	177800	8.2%
	114073	5.3%
8	94804	4.4%
7	69340	3.2%
3	30465	1.4%
5	23446	1.1%
Other values (3)	62355	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2167387	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	943524	43.5%
-	228146	10.5%
:	228146	10.5%
1	195288	9.0%
2	177800	8.2%
	114073	5.3%
8	94804	4.4%
7	69340	3.2%
3	30465	1.4%
5	23446	1.1%
Other values (3)	62355	2.9%

item_id
Real number (ℝ_≥0)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.197505106
Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Memory size	891.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	21
Range	20
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7031296814
Coefficient of variation (CV)	0.5871621571
Kurtosis	104.4504502
Mean	1.197505106
Median Absolute Deviation (MAD)	0
Skewness	7.605133406
Sum	136603
Variance	0.4943913489
Monotocity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	99866	87.5%
2	10006	8.8%
3	2321	2.0%
4	957	0.8%
5	448	0.4%
6	256	0.2%
7	61	0.1%
8	36	< 0.1%
9	29	< 0.1%
10	26	< 0.1%
Other values (11)	67	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	99866	87.5%
2	10006	8.8%
3	2321	2.0%
4	957	0.8%
5	448	0.4%

Value	Count	Frequency (%)
21	1	< 0.1%
20	3	< 0.1%
19	3	< 0.1%
18	3	< 0.1%
17	3	< 0.1%

produto_id
Categorical

HIGH CARDINALITY

Distinct	31625
Distinct (%)	27.7%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

aca2eb7d00ea1a7b8ebd4e68314663af	529
99a4788cb24856965c36a24e339b6058	516
422879e10f46682990de24d770e7f83d	508
389d119b48cf3043d311335e499d9c6b	403
368c6c730842d78016ad823897a372db	398
Other values (31620)	111719

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3650336
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16621 ?
Unique (%)	14.6%

Sample

1st row	87285b34884572647811a353c7ac498a
2nd row	87285b34884572647811a353c7ac498a
3rd row	87285b34884572647811a353c7ac498a
4th row	87285b34884572647811a353c7ac498a
5th row	87285b34884572647811a353c7ac498a

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	529	0.5%
99a4788cb24856965c36a24e339b6058	516	0.5%
422879e10f46682990de24d770e7f83d	508	0.4%
389d119b48cf3043d311335e499d9c6b	403	0.4%
368c6c730842d78016ad823897a372db	398	0.3%
53759a2ecddad2bb87a079a1f1519f73	391	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	346	0.3%
53b36df67ebb7c41585e8d54d6772e08	325	0.3%
154e7e31ebfa092203795c972e5804a6	287	0.3%
3dd2a17168ec895c781a9191c1e95ad7	276	0.2%
Other values (31615)	110094	96.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	529	0.5%
99a4788cb24856965c36a24e339b6058	516	0.5%
422879e10f46682990de24d770e7f83d	508	0.4%
389d119b48cf3043d311335e499d9c6b	403	0.4%
368c6c730842d78016ad823897a372db	398	0.3%
53759a2ecddad2bb87a079a1f1519f73	391	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	346	0.3%
53b36df67ebb7c41585e8d54d6772e08	325	0.3%
154e7e31ebfa092203795c972e5804a6	287	0.3%
3dd2a17168ec895c781a9191c1e95ad7	276	0.2%
Other values (31615)	110094	96.5%

Most occurring characters

Value	Count	Frequency (%)
3	234822	6.4%
9	232956	6.4%
e	230534	6.3%
7	230035	6.3%
8	229497	6.3%
4	228276	6.3%
2	227974	6.2%
0	227939	6.2%
c	227915	6.2%
a	227906	6.2%
Other values (6)	1352482	37.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2291579	62.8%
Lowercase Letter	1358757	37.2%

Most frequent character per category

Value	Count	Frequency (%)
3	234822	10.2%
9	232956	10.2%
7	230035	10.0%
8	229497	10.0%
4	228276	10.0%
2	227974	9.9%
0	227939	9.9%
6	227809	9.9%
5	226665	9.9%
1	225606	9.8%

Value	Count	Frequency (%)
e	230534	17.0%
c	227915	16.8%
a	227906	16.8%
b	226623	16.7%
d	224316	16.5%
f	221463	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	2291579	62.8%
Latin	1358757	37.2%

Most frequent character per script

Value	Count	Frequency (%)
3	234822	10.2%
9	232956	10.2%
7	230035	10.0%
8	229497	10.0%
4	228276	10.0%
2	227974	9.9%
0	227939	9.9%
6	227809	9.9%
5	226665	9.9%
1	225606	9.8%

Value	Count	Frequency (%)
e	230534	17.0%
c	227915	16.8%
a	227906	16.8%
b	226623	16.7%
d	224316	16.5%
f	221463	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3650336	100.0%

Most frequent character per block

Value	Count	Frequency (%)
3	234822	6.4%
9	232956	6.4%
e	230534	6.3%
7	230035	6.3%
8	229497	6.3%
4	228276	6.3%
2	227974	6.2%
0	227939	6.2%
c	227915	6.2%
a	227906	6.2%
Other values (6)	1352482	37.1%

vendedor_id
Categorical

HIGH CARDINALITY

Distinct	2914
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

4a3ca9315b744ce9f8e9374361493884	2116
6560211a19b47992c3666cc44a7e94c0	2093
1f50f920176fa81dab994f9023523100	2011
cc419e0650a3c5ba77189a1882b7556a	1832
da8622b14eb17ae2831f4ac5b9dab84a	1656
Other values (2909)	104365

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3650336
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	466 ?
Unique (%)	0.4%

Sample

1st row	3504c0cb71d7fa48d967e0e4c94d59d9
2nd row	3504c0cb71d7fa48d967e0e4c94d59d9
3rd row	3504c0cb71d7fa48d967e0e4c94d59d9
4th row	3504c0cb71d7fa48d967e0e4c94d59d9
5th row	3504c0cb71d7fa48d967e0e4c94d59d9

Value	Count	Frequency (%)
4a3ca9315b744ce9f8e9374361493884	2116	1.9%
6560211a19b47992c3666cc44a7e94c0	2093	1.8%
1f50f920176fa81dab994f9023523100	2011	1.8%
cc419e0650a3c5ba77189a1882b7556a	1832	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1656	1.5%
955fee9216a65b617aa5c0531780ce60	1503	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1468	1.3%
7c67e1448b00f6e969d365cea6b010ab	1454	1.3%
7a67c85e85bb2ce8582c35f2203ad736	1226	1.1%
ea8482cd71df3c1969d7b9473ff13abc	1224	1.1%
Other values (2904)	97490	85.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
4a3ca9315b744ce9f8e9374361493884	2116	1.9%
6560211a19b47992c3666cc44a7e94c0	2093	1.8%
1f50f920176fa81dab994f9023523100	2011	1.8%
cc419e0650a3c5ba77189a1882b7556a	1832	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1656	1.5%
955fee9216a65b617aa5c0531780ce60	1503	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1468	1.3%
7c67e1448b00f6e969d365cea6b010ab	1454	1.3%
7a67c85e85bb2ce8582c35f2203ad736	1226	1.1%
ea8482cd71df3c1969d7b9473ff13abc	1224	1.1%
Other values (2904)	97490	85.5%

Most occurring characters

Value	Count	Frequency (%)
1	248750	6.8%
c	240681	6.6%
4	239821	6.6%
6	234868	6.4%
0	234519	6.4%
a	233687	6.4%
b	232658	6.4%
3	232411	6.4%
9	225692	6.2%
2	224476	6.1%
Other values (6)	1302773	35.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2308365	63.2%
Lowercase Letter	1341971	36.8%

Most frequent character per category

Value	Count	Frequency (%)
1	248750	10.8%
4	239821	10.4%
6	234868	10.2%
0	234519	10.2%
3	232411	10.1%
9	225692	9.8%
2	224476	9.7%
8	223146	9.7%
5	222860	9.7%
7	221822	9.6%

Value	Count	Frequency (%)
c	240681	17.9%
a	233687	17.4%
b	232658	17.3%
e	213586	15.9%
f	211925	15.8%
d	209434	15.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2308365	63.2%
Latin	1341971	36.8%

Most frequent character per script

Value	Count	Frequency (%)
1	248750	10.8%
4	239821	10.4%
6	234868	10.2%
0	234519	10.2%
3	232411	10.1%
9	225692	9.8%
2	224476	9.7%
8	223146	9.7%
5	222860	9.7%
7	221822	9.6%

Value	Count	Frequency (%)
c	240681	17.9%
a	233687	17.4%
b	232658	17.3%
e	213586	15.9%
f	211925	15.8%
d	209434	15.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3650336	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	248750	6.8%
c	240681	6.6%
4	239821	6.6%
6	234868	6.4%
0	234519	6.4%
a	233687	6.4%
b	232658	6.4%
3	232411	6.4%
9	225692	6.2%
2	224476	6.1%
Other values (6)	1302773	35.7%

data_limite_envio
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	90127
Distinct (%)	79.0%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

2017-08-14 20:43:31	63
2017-10-05 17:44:41	38
2017-06-15 16:15:08	26
2018-02-27 12:28:15	24
2017-11-30 14:16:34	24
Other values (90122)	113898

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2167387
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	74372 ?
Unique (%)	65.2%

Sample

1st row	2017-10-06 11:07:15
2nd row	2017-10-06 11:07:15
3rd row	2017-10-06 11:07:15
4th row	2017-08-21 20:05:16
5th row	2017-08-08 18:37:31

Value	Count	Frequency (%)
2017-08-14 20:43:31	63	0.1%
2017-10-05 17:44:41	38	< 0.1%
2017-06-15 16:15:08	26	< 0.1%
2018-02-27 12:28:15	24	< 0.1%
2017-11-30 14:16:34	24	< 0.1%
2017-03-15 23:39:26	24	< 0.1%
2018-05-15 15:30:28	24	< 0.1%
2017-07-13 15:10:17	24	< 0.1%
2017-12-14 11:55:17	22	< 0.1%
2017-10-24 13:06:21	22	< 0.1%
Other values (90117)	113782	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-30	1695	0.7%
2017-12-07	771	0.3%
2018-04-19	702	0.3%
2018-05-10	678	0.3%
2018-01-18	665	0.3%
2018-08-07	660	0.3%
2018-02-22	655	0.3%
2018-03-08	653	0.3%
2018-03-01	650	0.3%
2018-03-22	646	0.3%
Other values (39882)	220371	96.6%

Most occurring characters

Value	Count	Frequency (%)
0	365817	16.9%
1	351003	16.2%
2	279255	12.9%
-	228146	10.5%
:	228146	10.5%
8	114943	5.3%
	114073	5.3%
3	110065	5.1%
5	108149	5.0%
7	98206	4.5%
Other values (3)	169584	7.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1597022	73.7%
Dash Punctuation	228146	10.5%
Other Punctuation	228146	10.5%
Space Separator	114073	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	365817	22.9%
1	351003	22.0%
2	279255	17.5%
8	114943	7.2%
3	110065	6.9%
5	108149	6.8%
7	98206	6.1%
4	76591	4.8%
6	47806	3.0%
9	45187	2.8%

Value	Count	Frequency (%)
-	228146	100.0%

Value	Count	Frequency (%)
	114073	100.0%

Value	Count	Frequency (%)
:	228146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2167387	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	365817	16.9%
1	351003	16.2%
2	279255	12.9%
-	228146	10.5%
:	228146	10.5%
8	114943	5.3%
	114073	5.3%
3	110065	5.1%
5	108149	5.0%
7	98206	4.5%
Other values (3)	169584	7.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2167387	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	365817	16.9%
1	351003	16.2%
2	279255	12.9%
-	228146	10.5%
:	228146	10.5%
8	114943	5.3%
	114073	5.3%
3	110065	5.1%
5	108149	5.0%
7	98206	4.5%
Other values (3)	169584	7.8%

preco
Real number (ℝ_≥0)

Distinct	5792
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	120.0157796
Minimum	0.85
Maximum	6735
Zeros	0
Zeros (%)	0.0%
Memory size	891.3 KiB

Quantile statistics

Minimum	0.85
5-th percentile	17
Q1	39.9
median	74.9
Q3	133
95-th percentile	349.9
Maximum	6735
Range	6734.15
Interquartile range (IQR)	93.1

Descriptive statistics

Standard deviation	182.4031879
Coefficient of variation (CV)	1.519826714
Kurtosis	123.0342856
Mean	120.0157796
Median Absolute Deviation (MAD)	41.91
Skewness	7.964132525
Sum	13690560.03
Variance	33270.92297
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.9	2561	2.2%
69.9	2064	1.8%
49.9	1993	1.7%
89.9	1599	1.4%
99.9	1486	1.3%
29.9	1353	1.2%
39.9	1317	1.2%
19.9	1261	1.1%
79.9	1247	1.1%
29.99	1203	1.1%
Other values (5782)	97989	85.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.85	3	< 0.1%
1.2	20	< 0.1%
2.2	2	< 0.1%
2.29	1	< 0.1%
2.9	1	< 0.1%

Value	Count	Frequency (%)
6735	1	< 0.1%
6729	1	< 0.1%
6499	1	< 0.1%
4799	1	< 0.1%
4690	1	< 0.1%

frete
Real number (ℝ_≥0)

Distinct	6902
Distinct (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.01002604
Minimum	0
Maximum	409.68
Zeros	386
Zeros (%)	0.3%
Memory size	891.3 KiB

Quantile statistics

Minimum	0
5-th percentile	7.78
Q1	13.08
median	16.32
Q3	21.19
95-th percentile	45.184
Maximum	409.68
Range	409.68
Interquartile range (IQR)	8.11

Descriptive statistics

Standard deviation	15.72648556
Coefficient of variation (CV)	0.7859302897
Kurtosis	58.94136685
Mean	20.01002604
Median Absolute Deviation (MAD)	3.63
Skewness	5.577070922
Sum	2282603.7
Variance	247.3223481
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.1	3721	3.3%
7.78	2255	2.0%
11.85	1920	1.7%
14.1	1900	1.7%
18.23	1587	1.4%
7.39	1534	1.3%
16.11	1178	1.0%
15.23	1034	0.9%
8.72	917	0.8%
16.79	898	0.8%
Other values (6892)	97129	85.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	386	0.3%
0.01	4	< 0.1%
0.02	3	< 0.1%
0.03	11	< 0.1%
0.04	4	< 0.1%

Value	Count	Frequency (%)
409.68	1	< 0.1%
375.28	2	< 0.1%
339.59	1	< 0.1%
338.3	1	< 0.1%
322.1	1	< 0.1%

pagamento_sequencial
Real number (ℝ_≥0)

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.090520982
Minimum	1
Maximum	26
Zeros	0
Zeros (%)	0.0%
Memory size	891.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	26
Range	25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6844869171
Coefficient of variation (CV)	0.6276696444
Kurtosis	311.8129445
Mean	1.090520982
Median Absolute Deviation (MAD)	0
Skewness	15.14089799
Sum	124399
Variance	0.4685223397
Monotocity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
1	109198	95.7%
2	3268	2.9%
3	632	0.6%
4	304	0.3%
5	181	0.2%
6	124	0.1%
7	85	0.1%
8	55	< 0.1%
9	44	< 0.1%
10	38	< 0.1%
Other values (16)	144	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	109198	95.7%
2	3268	2.9%
3	632	0.6%
4	304	0.3%
5	181	0.2%

Value	Count	Frequency (%)
26	1	< 0.1%
25	1	< 0.1%
24	1	< 0.1%
23	1	< 0.1%
22	2	< 0.1%

tipo_pagamento
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

credit_card	84183
boleto	22189
voucher	6068
debit_card	1633

Length

Max length	11
Median length	11
Mean length	9.800329613
Min length	6

Characters and Unicode

Total characters	1117953
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	credit_card
2nd row	voucher
3rd row	voucher
4th row	credit_card
5th row	credit_card

Value	Count	Frequency (%)
credit_card	84183	73.8%
boleto	22189	19.5%
voucher	6068	5.3%
debit_card	1633	1.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
credit_card	84183	73.8%
boleto	22189	19.5%
voucher	6068	5.3%
debit_card	1633	1.4%

Most occurring characters

Value	Count	Frequency (%)
c	176067	15.7%
r	176067	15.7%
d	171632	15.4%
e	114073	10.2%
t	108005	9.7%
i	85816	7.7%
_	85816	7.7%
a	85816	7.7%
o	50446	4.5%
b	23822	2.1%
Other values (4)	40393	3.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1032137	92.3%
Connector Punctuation	85816	7.7%

Most frequent character per category

Value	Count	Frequency (%)
c	176067	17.1%
r	176067	17.1%
d	171632	16.6%
e	114073	11.1%
t	108005	10.5%
i	85816	8.3%
a	85816	8.3%
o	50446	4.9%
b	23822	2.3%
l	22189	2.1%
Other values (3)	18204	1.8%

Value	Count	Frequency (%)
_	85816	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1032137	92.3%
Common	85816	7.7%

Most frequent character per script

Value	Count	Frequency (%)
c	176067	17.1%
r	176067	17.1%
d	171632	16.6%
e	114073	11.1%
t	108005	10.5%
i	85816	8.3%
a	85816	8.3%
o	50446	4.9%
b	23822	2.3%
l	22189	2.1%
Other values (3)	18204	1.8%

Value	Count	Frequency (%)
_	85816	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1117953	100.0%

Most frequent character per block

Value	Count	Frequency (%)
c	176067	15.7%
r	176067	15.7%
d	171632	15.4%
e	114073	10.2%
t	108005	9.7%
i	85816	7.7%
_	85816	7.7%
a	85816	7.7%
o	50446	4.5%
b	23822	2.1%
Other values (4)	40393	3.6%

prestacoes
Real number (ℝ_≥0)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.946446574
Minimum	0
Maximum	24
Zeros	3
Zeros (%)	< 0.1%
Memory size	891.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	10
Maximum	24
Range	24
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.781708287
Coefficient of variation (CV)	0.9440891655
Kurtosis	2.533879633
Mean	2.946446574
Median Absolute Deviation (MAD)	1
Skewness	1.620990854
Sum	336110
Variance	7.737900993
Monotocity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	56810	49.8%
2	13244	11.6%
3	11403	10.0%
4	7756	6.8%
10	6707	5.9%
5	5863	5.1%
8	4914	4.3%
6	4491	3.9%
7	1752	1.5%
9	705	0.6%
Other values (14)	428	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	56810	49.8%
2	13244	11.6%
3	11403	10.0%
4	7756	6.8%

Value	Count	Frequency (%)
24	34	< 0.1%
23	1	< 0.1%
22	1	< 0.1%
21	6	< 0.1%
20	20	< 0.1%

valor_pagamento
Real number (ℝ_≥0)

Distinct	28379
Distinct (%)	24.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	172.1428148
Minimum	0
Maximum	13664.08
Zeros	4
Zeros (%)	< 0.1%
Memory size	891.3 KiB

Quantile statistics

Minimum	0
5-th percentile	27.29
Q1	60.95
median	108.06
Q3	189.37
95-th percentile	512.79
Maximum	13664.08
Range	13664.08
Interquartile range (IQR)	128.42

Descriptive statistics

Standard deviation	266.1229149
Coefficient of variation (CV)	1.545942625
Kurtosis	531.8980401
Mean	172.1428148
Median Absolute Deviation (MAD)	56.6
Skewness	14.46917814
Sum	19636847.31
Variance	70821.40583
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	338	0.3%
100	293	0.3%
20	281	0.2%
77.57	245	0.2%
35	162	0.1%
73.34	158	0.1%
116.94	132	0.1%
30	130	0.1%
155.14	119	0.1%
107.78	118	0.1%
Other values (28369)	112097	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4	< 0.1%
0.01	6	< 0.1%
0.03	2	< 0.1%
0.05	2	< 0.1%
0.08	2	< 0.1%

Value	Count	Frequency (%)
13664.08	8	< 0.1%
7274.88	4	< 0.1%
6929.31	1	< 0.1%
6922.21	1	< 0.1%
6726.66	1	< 0.1%

id_review
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	94947
Distinct (%)	83.2%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

eef5dbca8d37dfce6db7d7b16dd0525e	63
7145a6f0d38ec713897856cbdcfcdb7f	38
8823bba1e3301fee652eb06de8ef9435	26
b0c2f8c122ebef9f77753f7d167cf634	24
cc074f1c33940c4f0dd904705f98e39e	24
Other values (94942)	113898

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3650336
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	82331 ?
Unique (%)	72.2%

Sample

1st row	a54f0611adc9ed256b57ede6b6eb5114
2nd row	a54f0611adc9ed256b57ede6b6eb5114
3rd row	a54f0611adc9ed256b57ede6b6eb5114
4th row	b46f1e34512b0f4c74a72398b03ca788
5th row	dc90f19c2806f1abba9e72ad3c350073

Value	Count	Frequency (%)
eef5dbca8d37dfce6db7d7b16dd0525e	63	0.1%
7145a6f0d38ec713897856cbdcfcdb7f	38	< 0.1%
8823bba1e3301fee652eb06de8ef9435	26	< 0.1%
b0c2f8c122ebef9f77753f7d167cf634	24	< 0.1%
cc074f1c33940c4f0dd904705f98e39e	24	< 0.1%
b79b22bb50f78f1afe361661011fd892	24	< 0.1%
b5292206f96cd5d97359940203a0b510	24	< 0.1%
7e568736c98c553aea896a5dca746d5a	22	< 0.1%
6fe49ee0a2b00dddf7ebddb5847f9283	21	< 0.1%
e8236fe7b6e1bdd513a500de361e2b87	21	< 0.1%
Other values (94937)	113786	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
eef5dbca8d37dfce6db7d7b16dd0525e	63	0.1%
7145a6f0d38ec713897856cbdcfcdb7f	38	< 0.1%
8823bba1e3301fee652eb06de8ef9435	26	< 0.1%
b0c2f8c122ebef9f77753f7d167cf634	24	< 0.1%
cc074f1c33940c4f0dd904705f98e39e	24	< 0.1%
b79b22bb50f78f1afe361661011fd892	24	< 0.1%
b5292206f96cd5d97359940203a0b510	24	< 0.1%
7e568736c98c553aea896a5dca746d5a	22	< 0.1%
6fe49ee0a2b00dddf7ebddb5847f9283	21	< 0.1%
e8236fe7b6e1bdd513a500de361e2b87	21	< 0.1%
Other values (94937)	113786	99.7%

Most occurring characters

Value	Count	Frequency (%)
6	229112	6.3%
a	228833	6.3%
5	228589	6.3%
d	228554	6.3%
f	228423	6.3%
b	228389	6.3%
8	228308	6.3%
1	228150	6.3%
0	228145	6.2%
c	228031	6.2%
Other values (6)	1365802	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2280313	62.5%
Lowercase Letter	1370023	37.5%

Most frequent character per category

Value	Count	Frequency (%)
6	229112	10.0%
5	228589	10.0%
8	228308	10.0%
1	228150	10.0%
0	228145	10.0%
7	228023	10.0%
2	227863	10.0%
9	227603	10.0%
4	227271	10.0%
3	227249	10.0%

Value	Count	Frequency (%)
a	228833	16.7%
d	228554	16.7%
f	228423	16.7%
b	228389	16.7%
c	228031	16.6%
e	227793	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2280313	62.5%
Latin	1370023	37.5%

Most frequent character per script

Value	Count	Frequency (%)
6	229112	10.0%
5	228589	10.0%
8	228308	10.0%
1	228150	10.0%
0	228145	10.0%
7	228023	10.0%
2	227863	10.0%
9	227603	10.0%
4	227271	10.0%
3	227249	10.0%

Value	Count	Frequency (%)
a	228833	16.7%
d	228554	16.7%
f	228423	16.7%
b	228389	16.7%
c	228031	16.6%
e	227793	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3650336	100.0%

Most frequent character per block

Value	Count	Frequency (%)
6	229112	6.3%
a	228833	6.3%
5	228589	6.3%
d	228554	6.3%
f	228423	6.3%
b	228389	6.3%
8	228308	6.3%
1	228150	6.3%
0	228145	6.2%
c	228031	6.2%
Other values (6)	1365802	37.4%

review_score
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

5	65250
4	21878
1	13352
3	9647
2	3946

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	114073
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	5

Value	Count	Frequency (%)
5	65250	57.2%
4	21878	19.2%
1	13352	11.7%
3	9647	8.5%
2	3946	3.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
5	65250	57.2%
4	21878	19.2%
1	13352	11.7%
3	9647	8.5%
2	3946	3.5%

Most occurring characters

Value	Count	Frequency (%)
5	65250	57.2%
4	21878	19.2%
1	13352	11.7%
3	9647	8.5%
2	3946	3.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	114073	100.0%

Most frequent character per category

Value	Count	Frequency (%)
5	65250	57.2%
4	21878	19.2%
1	13352	11.7%
3	9647	8.5%
2	3946	3.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	114073	100.0%

Most frequent character per script

Value	Count	Frequency (%)
5	65250	57.2%
4	21878	19.2%
1	13352	11.7%
3	9647	8.5%
2	3946	3.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	114073	100.0%

Most frequent character per block

Value	Count	Frequency (%)
5	65250	57.2%
4	21878	19.2%
1	13352	11.7%
3	9647	8.5%
2	3946	3.5%

titulo_review
Categorical

HIGH CARDINALITY
MISSING

Distinct	4409
Distinct (%)	32.3%
Missing	100406
Missing (%)	88.0%
Memory size	891.3 KiB

Recomendo	492
recomendo	399
Bom	328
super recomendo	311
Excelente	293
Other values (4404)	11844

Length

Max length	26
Median length	11
Mean length	12.15841077
Min length	1

Characters and Unicode

Total characters	166169
Distinct characters	125
Distinct categories	13 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3001 ?
Unique (%)	22.0%

Sample

1st row	Muito boa a loja
2nd row	super recomendo
3rd row	Muito bom
4th row	super recomendo
5th row	super recomendo

Value	Count	Frequency (%)
Recomendo	492	0.4%
recomendo	399	0.3%
Bom	328	0.3%
super recomendo	311	0.3%
Excelente	293	0.3%
Muito bom	277	0.2%
Ótimo	266	0.2%
Super recomendo	251	0.2%
Ótimo	234	0.2%
Otimo	201	0.2%
Other values (4399)	10615	9.3%
(Missing)	100406	88.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
recomendo	2432	9.4%
bom	1517	5.8%
produto	1507	5.8%
super	1035	4.0%
muito	1030	4.0%
não	832	3.2%
ótimo	799	3.1%
excelente	762	2.9%
entrega	693	2.7%
otimo	417	1.6%
Other values (2051)	14976	57.6%

Most occurring characters

Value	Count	Frequency (%)
o	20694	12.5%
e	17800	10.7%
	14688	8.8%
r	9615	5.8%
t	9217	5.5%
a	8903	5.4%
m	8252	5.0%
d	8016	4.8%
i	7885	4.7%
n	7412	4.5%
Other values (115)	53687	32.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	129186	77.7%
Uppercase Letter	18340	11.0%
Space Separator	14688	8.8%
Other Punctuation	2631	1.6%
Decimal Number	1224	0.7%
Other Symbol	49	< 0.1%
Dash Punctuation	16	< 0.1%
Modifier Symbol	13	< 0.1%
Math Symbol	8	< 0.1%
Close Punctuation	7	< 0.1%
Other values (3)	7	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
o	20694	16.0%
e	17800	13.8%
r	9615	7.4%
t	9217	7.1%
a	8903	6.9%
m	8252	6.4%
d	8016	6.2%
i	7885	6.1%
n	7412	5.7%
c	5789	4.5%
Other values (31)	25603	19.8%

Value	Count	Frequency (%)
E	2480	13.5%
R	2001	10.9%
O	1627	8.9%
P	1552	8.5%
M	1429	7.8%
N	1118	6.1%
S	1036	5.6%
A	937	5.1%
Ó	924	5.0%
B	889	4.8%
Other values (26)	4347	23.7%

Value	Count	Frequency (%)
!	1185	45.0%
.	785	29.8%
*	396	15.1%
,	151	5.7%
?	43	1.6%
/	33	1.3%
%	19	0.7%
:	6	0.2%
;	4	0.2%
"	3	0.1%
Other values (4)	6	0.2%

Value	Count	Frequency (%)
👍	16	32.7%
😍	9	18.4%
👏	7	14.3%
🌟	6	12.2%
💥	5	10.2%
🚚	1	2.0%
🔟	1	2.0%
😀	1	2.0%
🤗	1	2.0%
👎	1	2.0%

Value	Count	Frequency (%)
0	465	38.0%
1	419	34.2%
5	76	6.2%
2	72	5.9%
8	45	3.7%
3	41	3.3%
4	39	3.2%
9	29	2.4%
7	22	1.8%
6	16	1.3%

Value	Count	Frequency (%)
´	6	46.2%
🏻	3	23.1%
🏽	2	15.4%
🏼	2	15.4%

Value	Count	Frequency (%)
+	7	87.5%
=	1	12.5%

Value	Count	Frequency (%)
)	6	85.7%
]	1	14.3%

Value	Count	Frequency (%)
	14688	100.0%

Value	Count	Frequency (%)
-	16	100.0%

Value	Count	Frequency (%)
(	1	100.0%

Value	Count	Frequency (%)
ª	1	100.0%

Value	Count	Frequency (%)
$	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	147527	88.8%
Common	18642	11.2%

Most frequent character per script

Value	Count	Frequency (%)
o	20694	14.0%
e	17800	12.1%
r	9615	6.5%
t	9217	6.2%
a	8903	6.0%
m	8252	5.6%
d	8016	5.4%
i	7885	5.3%
n	7412	5.0%
c	5789	3.9%
Other values (68)	43944	29.8%

Value	Count	Frequency (%)
	14688	78.8%
!	1185	6.4%
.	785	4.2%
0	465	2.5%
1	419	2.2%
*	396	2.1%
,	151	0.8%
5	76	0.4%
2	72	0.4%
8	45	0.2%
Other values (37)	360	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	162679	97.9%
None	3479	2.1%
Emoticons	11	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
o	20694	12.7%
e	17800	10.9%
	14688	9.0%
r	9615	5.9%
t	9217	5.7%
a	8903	5.5%
m	8252	5.1%
d	8016	4.9%
i	7885	4.8%
n	7412	4.6%
Other values (74)	50197	30.9%

Value	Count	Frequency (%)
ã	1013	29.1%
Ó	924	26.6%
á	354	10.2%
ç	341	9.8%
é	253	7.3%
ó	245	7.0%
Ã	65	1.9%
í	61	1.8%
ê	41	1.2%
É	30	0.9%
Other values (28)	152	4.4%

Value	Count	Frequency (%)
😍	9	81.8%
😀	1	9.1%
😤	1	9.1%

comentario_review
Categorical

HIGH CARDINALITY
MISSING

Distinct	34589
Distinct (%)	71.7%
Missing	65847
Missing (%)	57.7%
Memory size	891.3 KiB

Muito bom	253
Bom	206
muito bom	135
bom	115
Otimo	114
Other values (34584)	47403

Length

Max length	208
Median length	55
Mean length	70.80174595
Min length	1

Characters and Unicode

Total characters	3414485
Distinct characters	208
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	28172 ?
Unique (%)	58.4%

Sample

1st row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
2nd row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
3rd row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
4th row	Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente.
5th row	Só achei ela pequena pra seis xícaras ,mais é um bom produto

Value	Count	Frequency (%)
Muito bom	253	0.2%
Bom	206	0.2%
muito bom	135	0.1%
bom	115	0.1%
Otimo	114	0.1%
Recomendo	108	0.1%
otimo	102	0.1%
Ok	87	0.1%
Ótimo	84	0.1%
Ótimo	82	0.1%
Other values (34579)	46940	41.1%
(Missing)	65847	57.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
o	21645	3.7%
produto	20063	3.4%
e	19229	3.3%
a	14594	2.5%
de	14021	2.4%
do	12727	2.2%
não	12028	2.1%
que	10069	1.7%
prazo	9137	1.6%
muito	8959	1.5%
Other values (19513)	439641	75.5%

Most occurring characters

Value	Count	Frequency (%)
	540024	15.8%
o	335858	9.8%
e	327292	9.6%
a	269792	7.9%
r	191802	5.6%
i	157267	4.6%
t	155267	4.5%
d	144525	4.2%
n	131696	3.9%
s	128449	3.8%
Other values (198)	1032513	30.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2574732	75.4%
Space Separator	540024	15.8%
Uppercase Letter	165143	4.8%
Other Punctuation	93322	2.7%
Decimal Number	23872	0.7%
Control	13763	0.4%
Dash Punctuation	1080	< 0.1%
Close Punctuation	735	< 0.1%
Open Punctuation	717	< 0.1%
Other Symbol	704	< 0.1%
Other values (5)	393	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
👏	242	34.4%
👍	86	12.2%
😍	74	10.5%
°	32	4.5%
😡	22	3.1%
😉	22	3.1%
😘	20	2.8%
😆	19	2.7%
👎	15	2.1%
😁	13	1.8%
Other values (54)	159	22.6%

Value	Count	Frequency (%)
o	335858	13.0%
e	327292	12.7%
a	269792	10.5%
r	191802	7.4%
i	157267	6.1%
t	155267	6.0%
d	144525	5.6%
n	131696	5.1%
s	128449	5.0%
m	123372	4.8%
Other values (39)	609412	23.7%

Value	Count	Frequency (%)
E	19586	11.9%
O	18433	11.2%
A	16975	10.3%
P	12254	7.4%
R	12031	7.3%
C	9635	5.8%
N	9233	5.6%
M	9227	5.6%
S	8166	4.9%
T	7774	4.7%
Other values (31)	41829	25.3%

Value	Count	Frequency (%)
.	49058	52.6%
,	27526	29.5%
!	12219	13.1%
/	1681	1.8%
?	1523	1.6%
"	401	0.4%
:	348	0.4%
;	219	0.2%
%	192	0.2%
*	76	0.1%
Other values (6)	79	0.1%

Value	Count	Frequency (%)
0	5182	21.7%
1	5076	21.3%
2	4341	18.2%
3	2396	10.0%
4	1586	6.6%
5	1415	5.9%
6	1149	4.8%
8	1093	4.6%
7	924	3.9%
9	710	3.0%

Value	Count	Frequency (%)
+	86	59.7%
=	29	20.1%
\|	12	8.3%
<	9	6.2%
~	3	2.1%
>	2	1.4%
×	2	1.4%
÷	1	0.7%

Value	Count	Frequency (%)
🏻	34	33.3%
´	26	25.5%
🏼	15	14.7%
🏽	13	12.7%
^	8	7.8%
🏾	4	3.9%
`	2	2.0%

Value	Count	Frequency (%)
	6874	49.9%
	6868	49.9%
	21	0.2%

Value	Count	Frequency (%)
(	711	99.2%
[	6	0.8%

Value	Count	Frequency (%)
)	733	99.7%
]	2	0.3%

Value	Count	Frequency (%)
º	29	61.7%
ª	18	38.3%

Value	Count	Frequency (%)
	540024	100.0%

Value	Count	Frequency (%)
_	14	100.0%

Value	Count	Frequency (%)
-	1080	100.0%

Value	Count	Frequency (%)
$	86	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2739922	80.2%
Common	674563	19.8%

Most frequent character per script

Value	Count	Frequency (%)
	540024	80.1%
.	49058	7.3%
,	27526	4.1%
!	12219	1.8%
	6874	1.0%
	6868	1.0%
0	5182	0.8%
1	5076	0.8%
2	4341	0.6%
3	2396	0.4%
Other values (106)	14999	2.2%

Value	Count	Frequency (%)
o	335858	12.3%
e	327292	11.9%
a	269792	9.8%
r	191802	7.0%
i	157267	5.7%
t	155267	5.7%
d	144525	5.3%
n	131696	4.8%
s	128449	4.7%
m	123372	4.5%
Other values (82)	774602	28.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3352823	98.2%
None	61412	1.8%
Emoticons	250	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	540024	16.1%
o	335858	10.0%
e	327292	9.8%
a	269792	8.0%
r	191802	5.7%
i	157267	4.7%
t	155267	4.6%
d	144525	4.3%
n	131696	3.9%
s	128449	3.8%
Other values (86)	970851	29.0%

Value	Count	Frequency (%)
ã	17535	28.6%
é	11081	18.0%
á	8821	14.4%
ç	7486	12.2%
ó	6255	10.2%
ê	1859	3.0%
í	1708	2.8%
Ó	1547	2.5%
õ	904	1.5%
ú	892	1.5%
Other values (71)	3324	5.4%

Value	Count	Frequency (%)
😍	74	29.6%
😡	22	8.8%
😉	22	8.8%
😘	20	8.0%
😆	19	7.6%
😁	13	5.2%
😊	12	4.8%
😀	8	3.2%
😩	7	2.8%
😃	6	2.4%
Other values (21)	47	18.8%

data_criacao_review
Categorical

HIGH CARDINALITY

Distinct	627
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

2017-12-19 00:00:00	526
2018-05-15 00:00:00	521
2018-05-22 00:00:00	520
2018-08-28 00:00:00	502
2017-12-20 00:00:00	501
Other values (622)	111503

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2167387
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27 ?
Unique (%)	< 0.1%

Sample

1st row	2017-10-11 00:00:00
2nd row	2017-10-11 00:00:00
3rd row	2017-10-11 00:00:00
4th row	2017-08-19 00:00:00
5th row	2017-08-08 00:00:00

Value	Count	Frequency (%)
2017-12-19 00:00:00	526	0.5%
2018-05-15 00:00:00	521	0.5%
2018-05-22 00:00:00	520	0.5%
2018-08-28 00:00:00	502	0.4%
2017-12-20 00:00:00	501	0.4%
2018-05-04 00:00:00	497	0.4%
2018-05-19 00:00:00	493	0.4%
2018-03-29 00:00:00	490	0.4%
2018-08-14 00:00:00	480	0.4%
2017-12-13 00:00:00	474	0.4%
Other values (617)	109069	95.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	113981	50.0%
2017-12-19	526	0.2%
2018-05-15	521	0.2%
2018-05-22	520	0.2%
2018-08-28	502	0.2%
2017-12-20	501	0.2%
2018-05-04	497	0.2%
2018-05-19	493	0.2%
2018-03-29	490	0.2%
2018-08-14	480	0.2%
Other values (619)	109635	48.1%

Most occurring characters

Value	Count	Frequency (%)
0	940260	43.4%
-	228146	10.5%
:	228146	10.5%
1	197907	9.1%
2	182136	8.4%
	114073	5.3%
8	91669	4.2%
7	71428	3.3%
3	27906	1.3%
5	24447	1.1%
Other values (3)	61269	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1597022	73.7%
Dash Punctuation	228146	10.5%
Other Punctuation	228146	10.5%
Space Separator	114073	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	940260	58.9%
1	197907	12.4%
2	182136	11.4%
8	91669	5.7%
7	71428	4.5%
3	27906	1.7%
5	24447	1.5%
4	22902	1.4%
6	22694	1.4%
9	15673	1.0%

Value	Count	Frequency (%)
-	228146	100.0%

Value	Count	Frequency (%)
	114073	100.0%

Value	Count	Frequency (%)
:	228146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2167387	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	940260	43.4%
-	228146	10.5%
:	228146	10.5%
1	197907	9.1%
2	182136	8.4%
	114073	5.3%
8	91669	4.2%
7	71428	3.3%
3	27906	1.3%
5	24447	1.1%
Other values (3)	61269	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2167387	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	940260	43.4%
-	228146	10.5%
:	228146	10.5%
1	197907	9.1%
2	182136	8.4%
	114073	5.3%
8	91669	4.2%
7	71428	3.3%
3	27906	1.3%
5	24447	1.1%
Other values (3)	61269	2.8%

data_resposta_review
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	94800
Distinct (%)	83.1%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

2017-08-17 22:17:55	63
2017-10-19 21:08:44	38
2017-06-28 18:49:50	26
2018-06-04 19:04:20	24
2018-03-07 15:08:10	24
Other values (94795)	113898

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2167387
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	82080 ?
Unique (%)	72.0%

Sample

1st row	2017-10-12 03:43:48
2nd row	2017-10-12 03:43:48
3rd row	2017-10-12 03:43:48
4th row	2017-08-20 15:16:36
5th row	2017-08-08 23:26:23

Value	Count	Frequency (%)
2017-08-17 22:17:55	63	0.1%
2017-10-19 21:08:44	38	< 0.1%
2017-06-28 18:49:50	26	< 0.1%
2018-06-04 19:04:20	24	< 0.1%
2018-03-07 15:08:10	24	< 0.1%
2017-03-23 08:34:13	24	< 0.1%
2017-08-01 13:20:31	24	< 0.1%
2017-12-22 20:33:52	22	< 0.1%
2018-06-15 19:25:55	21	< 0.1%
2018-02-19 20:04:36	21	< 0.1%
Other values (94790)	113786	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-05-20	757	0.3%
2018-05-21	679	0.3%
2018-05-10	577	0.3%
2017-12-20	465	0.2%
2017-12-13	417	0.2%
2018-05-11	415	0.2%
2018-04-13	412	0.2%
2018-08-24	406	0.2%
2017-12-22	400	0.2%
2017-12-21	398	0.2%
Other values (52941)	223220	97.8%

Most occurring characters

Value	Count	Frequency (%)
0	365214	16.9%
1	337956	15.6%
2	289281	13.3%
-	228146	10.5%
:	228146	10.5%
8	120505	5.6%
	114073	5.3%
3	105945	4.9%
7	98302	4.5%
5	90353	4.2%
Other values (3)	189466	8.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1597022	73.7%
Dash Punctuation	228146	10.5%
Other Punctuation	228146	10.5%
Space Separator	114073	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	365214	22.9%
1	337956	21.2%
2	289281	18.1%
8	120505	7.5%
3	105945	6.6%
7	98302	6.2%
5	90353	5.7%
4	90021	5.6%
6	51470	3.2%
9	47975	3.0%

Value	Count	Frequency (%)
-	228146	100.0%

Value	Count	Frequency (%)
	114073	100.0%

Value	Count	Frequency (%)
:	228146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2167387	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	365214	16.9%
1	337956	15.6%
2	289281	13.3%
-	228146	10.5%
:	228146	10.5%
8	120505	5.6%
	114073	5.3%
3	105945	4.9%
7	98302	4.5%
5	90353	4.2%
Other values (3)	189466	8.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2167387	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	365214	16.9%
1	337956	15.6%
2	289281	13.3%
-	228146	10.5%
:	228146	10.5%
8	120505	5.6%
	114073	5.3%
3	105945	4.9%
7	98302	4.5%
5	90353	4.2%
Other values (3)	189466	8.7%

categoria_produto
Categorical

HIGH CARDINALITY

Distinct	73
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

cama_mesa_banho	11815
beleza_saude	9816
esporte_lazer	8790
moveis_decoracao	8640
informatica_acessorios	7963
Other values (68)	67049

Length

Max length	46
Median length	15
Mean length	14.87437869
Min length	3

Characters and Unicode

Total characters	1696765
Distinct characters	28
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	utilidades_domesticas
2nd row	utilidades_domesticas
3rd row	utilidades_domesticas
4th row	utilidades_domesticas
5th row	utilidades_domesticas

Value	Count	Frequency (%)
cama_mesa_banho	11815	10.4%
beleza_saude	9816	8.6%
esporte_lazer	8790	7.7%
moveis_decoracao	8640	7.6%
informatica_acessorios	7963	7.0%
utilidades_domesticas	7196	6.3%
relogios_presentes	6075	5.3%
telefonia	4605	4.0%
ferramentas_jardim	4479	3.9%
automotivo	4301	3.8%
Other values (63)	40393	35.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
cama_mesa_banho	11815	10.4%
beleza_saude	9816	8.6%
esporte_lazer	8790	7.7%
moveis_decoracao	8640	7.6%
informatica_acessorios	7963	7.0%
utilidades_domesticas	7196	6.3%
relogios_presentes	6075	5.3%
telefonia	4605	4.0%
ferramentas_jardim	4479	3.9%
automotivo	4301	3.8%
Other values (63)	40393	35.4%

Most occurring characters

Value	Count	Frequency (%)
e	205827	12.1%
a	204478	12.1%
s	169017	10.0%
o	167967	9.9%
i	112530	6.6%
r	108962	6.4%
_	108191	6.4%
t	81385	4.8%
c	80755	4.8%
m	77055	4.5%
Other values (18)	380598	22.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1588279	93.6%
Connector Punctuation	108191	6.4%
Decimal Number	295	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	205827	13.0%
a	204478	12.9%
s	169017	10.6%
o	167967	10.6%
i	112530	7.1%
r	108962	6.9%
t	81385	5.1%
c	80755	5.1%
m	77055	4.9%
n	57892	3.6%
Other values (16)	322411	20.3%

Value	Count	Frequency (%)
_	108191	100.0%

Value	Count	Frequency (%)
2	295	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1588279	93.6%
Common	108486	6.4%

Most frequent character per script

Value	Count	Frequency (%)
e	205827	13.0%
a	204478	12.9%
s	169017	10.6%
o	167967	10.6%
i	112530	7.1%
r	108962	6.9%
t	81385	5.1%
c	80755	5.1%
m	77055	4.9%
n	57892	3.6%
Other values (16)	322411	20.3%

Value	Count	Frequency (%)
_	108191	99.7%
2	295	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1696765	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	205827	12.1%
a	204478	12.1%
s	169017	10.0%
o	167967	9.9%
i	112530	6.6%
r	108962	6.4%
_	108191	6.4%
t	81385	4.8%
c	80755	4.8%
m	77055	4.5%
Other values (18)	380598	22.4%

qtd_fotos_produto
Real number (ℝ_≥0)

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.206481814
Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Memory size	891.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	6
Maximum	20
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.718005821
Coefficient of variation (CV)	0.7786177117
Kurtosis	4.755824682
Mean	2.206481814
Median Absolute Deviation (MAD)	0
Skewness	1.902739279
Sum	251700
Variance	2.951544002
Monotocity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	57640	50.5%
2	22552	19.8%
3	12716	11.1%
4	8663	7.6%
5	5492	4.8%
6	3869	3.4%
7	1529	1.3%
8	760	0.7%
10	347	0.3%
9	309	0.3%
Other values (9)	196	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	57640	50.5%
2	22552	19.8%
3	12716	11.1%
4	8663	7.6%
5	5492	4.8%

Value	Count	Frequency (%)
20	1	< 0.1%
19	1	< 0.1%
18	4	< 0.1%
17	11	< 0.1%
15	11	< 0.1%

peso_produto
Real number (ℝ_≥0)

Distinct	2169
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2108.578051
Minimum	0
Maximum	40425
Zeros	8
Zeros (%)	< 0.1%
Memory size	891.3 KiB

Quantile statistics

Minimum	0
5-th percentile	125
Q1	300
median	700
Q3	1800
95-th percentile	9800
Maximum	40425
Range	40425
Interquartile range (IQR)	1500

Descriptive statistics

Standard deviation	3768.377345
Coefficient of variation (CV)	1.787165215
Kurtosis	16.1212629
Mean	2108.578051
Median Absolute Deviation (MAD)	500
Skewness	3.586967024
Sum	240531824
Variance	14200667.82
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	6757	5.9%
150	5293	4.6%
250	4620	4.1%
300	4246	3.7%
100	3509	3.1%
400	3425	3.0%
350	3184	2.8%
600	2742	2.4%
500	2723	2.4%
700	2078	1.8%
Other values (2159)	75496	66.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	< 0.1%
2	5	< 0.1%
25	3	< 0.1%
50	915	0.8%
53	2	< 0.1%

Value	Count	Frequency (%)
40425	3	< 0.1%
30000	290	0.3%
29800	1	< 0.1%
29700	3	< 0.1%
29600	5	< 0.1%

comprimento_produto
Real number (ℝ_≥0)

Distinct	99
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	30.28853453
Minimum	7
Maximum	105
Zeros	0
Zeros (%)	0.0%
Memory size	891.3 KiB

Quantile statistics

Minimum	7
5-th percentile	16
Q1	18
median	25
Q3	38
95-th percentile	62
Maximum	105
Range	98
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	16.15736235
Coefficient of variation (CV)	0.533448138
Kurtosis	3.62841728
Mean	30.28853453
Median Absolute Deviation (MAD)	8
Skewness	1.733817354
Sum	3455104
Variance	261.0603581
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	17500	15.3%
20	10443	9.2%
30	7732	6.8%
17	6039	5.3%
18	5710	5.0%
19	4786	4.2%
25	4724	4.1%
40	4178	3.7%
22	3887	3.4%
50	3051	2.7%
Other values (89)	46023	40.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	32	< 0.1%
8	2	< 0.1%
9	4	< 0.1%
10	8	< 0.1%
11	96	0.1%

Value	Count	Frequency (%)
105	311	0.3%
104	35	< 0.1%
103	45	< 0.1%
102	60	0.1%
101	107	0.1%

altura_produto
Real number (ℝ_≥0)

Distinct	102
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.60698851
Minimum	2
Maximum	105
Zeros	0
Zeros (%)	0.0%
Memory size	891.3 KiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	13
Q3	20
95-th percentile	45
Maximum	105
Range	103
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	13.43962315
Coefficient of variation (CV)	0.8092751519
Kurtosis	7.284949109
Mean	16.60698851
Median Absolute Deviation (MAD)	6
Skewness	2.242525757
Sum	1894409
Variance	180.6234703
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	10091	8.8%
15	6698	5.9%
20	6684	5.9%
11	6218	5.5%
12	6143	5.4%
2	5029	4.4%
4	4724	4.1%
8	4716	4.1%
16	4611	4.0%
5	4572	4.0%
Other values (92)	54587	47.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	5029	4.4%
3	2748	2.4%
4	4724	4.1%
5	4572	4.0%
6	3478	3.0%

Value	Count	Frequency (%)
105	134	0.1%
104	12	< 0.1%
103	49	< 0.1%
102	10	< 0.1%
100	40	< 0.1%

largura_produto
Real number (ℝ_≥0)

Distinct	94
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.1050906
Minimum	6
Maximum	118
Zeros	0
Zeros (%)	0.0%
Memory size	891.3 KiB

Quantile statistics

Minimum	6
5-th percentile	11
Q1	15
median	20
Q3	30
95-th percentile	45
Maximum	118
Range	112
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.73968495
Coefficient of variation (CV)	0.5080994988
Kurtosis	4.560336619
Mean	23.1050906
Median Absolute Deviation (MAD)	6
Skewness	1.705271877
Sum	2635667
Variance	137.8202028
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	12285	10.8%
11	10522	9.2%
15	8836	7.7%
16	8564	7.5%
30	7803	6.8%
12	5515	4.8%
13	5354	4.7%
14	4694	4.1%
18	4071	3.6%
40	3999	3.5%
Other values (84)	42430	37.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	2	< 0.1%
7	5	< 0.1%
8	29	< 0.1%
9	49	< 0.1%
10	81	0.1%

Value	Count	Frequency (%)
118	8	< 0.1%
105	13	< 0.1%
104	1	< 0.1%
102	2	< 0.1%
101	2	< 0.1%

id_unico_consumidor
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	92081
Distinct (%)	80.7%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

9a736b248f67d166d2fbb006bcb877c3	75
6fbc7cdadbb522125f4b27ae9dee4060	38
f9ae226291893fda10af7965268fb7f6	35
569aa12b73b5f7edeaa6f2a01603e381	26
1d2435aa3b858d45c707c9fc25e18779	24
Other values (92076)	113875

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3650336
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	78205 ?
Unique (%)	68.6%

Sample

1st row	7c396fd4830fd04220f754e42b4e5bff
2nd row	7c396fd4830fd04220f754e42b4e5bff
3rd row	7c396fd4830fd04220f754e42b4e5bff
4th row	3a51803cc0d012c3b5dc8b7528cb05f7
5th row	ef0996a1a279c26e7ecbd737be23d235

Value	Count	Frequency (%)
9a736b248f67d166d2fbb006bcb877c3	75	0.1%
6fbc7cdadbb522125f4b27ae9dee4060	38	< 0.1%
f9ae226291893fda10af7965268fb7f6	35	< 0.1%
569aa12b73b5f7edeaa6f2a01603e381	26	< 0.1%
1d2435aa3b858d45c707c9fc25e18779	24	< 0.1%
d97b3cfb22b0d6b25ac9ed4e9c2d481b	24	< 0.1%
5419a7c9b86a43d8140e2939cd2c2f7e	24	< 0.1%
db1af3fd6b23ac3873ef02619d548f9c	24	< 0.1%
85963fd37bfd387aa6d915d8a1065486	24	< 0.1%
90807fdb59eec2152bc977feeb6e47e7	24	< 0.1%
Other values (92071)	113755	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
9a736b248f67d166d2fbb006bcb877c3	75	0.1%
6fbc7cdadbb522125f4b27ae9dee4060	38	< 0.1%
f9ae226291893fda10af7965268fb7f6	35	< 0.1%
569aa12b73b5f7edeaa6f2a01603e381	26	< 0.1%
1d2435aa3b858d45c707c9fc25e18779	24	< 0.1%
d97b3cfb22b0d6b25ac9ed4e9c2d481b	24	< 0.1%
5419a7c9b86a43d8140e2939cd2c2f7e	24	< 0.1%
db1af3fd6b23ac3873ef02619d548f9c	24	< 0.1%
85963fd37bfd387aa6d915d8a1065486	24	< 0.1%
90807fdb59eec2152bc977feeb6e47e7	24	< 0.1%
Other values (92071)	113755	99.7%

Most occurring characters

Value	Count	Frequency (%)
6	229236	6.3%
1	228583	6.3%
b	228569	6.3%
a	228376	6.3%
d	228355	6.3%
e	228263	6.3%
3	228249	6.3%
9	228192	6.3%
5	228173	6.3%
8	228109	6.2%
Other values (6)	1366231	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2281577	62.5%
Lowercase Letter	1368759	37.5%

Most frequent character per category

Value	Count	Frequency (%)
6	229236	10.0%
1	228583	10.0%
3	228249	10.0%
9	228192	10.0%
5	228173	10.0%
8	228109	10.0%
2	228085	10.0%
7	227968	10.0%
0	227741	10.0%
4	227241	10.0%

Value	Count	Frequency (%)
b	228569	16.7%
a	228376	16.7%
d	228355	16.7%
e	228263	16.7%
f	227848	16.6%
c	227348	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2281577	62.5%
Latin	1368759	37.5%

Most frequent character per script

Value	Count	Frequency (%)
6	229236	10.0%
1	228583	10.0%
3	228249	10.0%
9	228192	10.0%
5	228173	10.0%
8	228109	10.0%
2	228085	10.0%
7	227968	10.0%
0	227741	10.0%
4	227241	10.0%

Value	Count	Frequency (%)
b	228569	16.7%
a	228376	16.7%
d	228355	16.7%
e	228263	16.7%
f	227848	16.6%
c	227348	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3650336	100.0%

Most frequent character per block

Value	Count	Frequency (%)
6	229236	6.3%
1	228583	6.3%
b	228569	6.3%
a	228376	6.3%
d	228355	6.3%
e	228263	6.3%
3	228249	6.3%
9	228192	6.3%
5	228173	6.3%
8	228109	6.2%
Other values (6)	1366231	37.4%

cep_consumidor
Real number (ℝ_≥0)

Distinct	14844
Distinct (%)	13.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	35079.90608
Minimum	1003
Maximum	99980
Zeros	0
Zeros (%)	0.0%
Memory size	891.3 KiB

Quantile statistics

Minimum	1003
5-th percentile	3281.6
Q1	11310
median	24320
Q3	58780
95-th percentile	90620
Maximum	99980
Range	98977
Interquartile range (IQR)	47470

Descriptive statistics

Standard deviation	29848.80558
Coefficient of variation (CV)	0.8508804305
Kurtosis	-0.7850673193
Mean	35079.90608
Median Absolute Deviation (MAD)	16298
Skewness	0.7838033662
Sum	4001670126
Variance	890951194.8
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24220	152	0.1%
22793	147	0.1%
22790	146	0.1%
24230	138	0.1%
35162	123	0.1%
22775	119	0.1%
29101	118	0.1%
13087	108	0.1%
36570	103	0.1%
11740	100	0.1%
Other values (14834)	112819	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1003	1	< 0.1%
1004	2	< 0.1%
1005	6	< 0.1%
1006	2	< 0.1%
1007	4	< 0.1%

Value	Count	Frequency (%)
99980	3	< 0.1%
99970	1	< 0.1%
99965	2	< 0.1%
99960	1	< 0.1%
99955	3	< 0.1%

cidade_consumidor
Categorical

HIGH CARDINALITY

Distinct	4073
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

sao paulo	18003
rio de janeiro	7873
belo horizonte	3160
brasilia	2400
curitiba	1775
Other values (4068)	80862

Length

Max length	32
Median length	9
Mean length	10.33448756
Min length	3

Characters and Unicode

Total characters	1178886
Distinct characters	31
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1031 ?
Unique (%)	0.9%

Sample

1st row	sao paulo
2nd row	sao paulo
3rd row	sao paulo
4th row	sao paulo
5th row	sao paulo

Value	Count	Frequency (%)
sao paulo	18003	15.8%
rio de janeiro	7873	6.9%
belo horizonte	3160	2.8%
brasilia	2400	2.1%
curitiba	1775	1.6%
campinas	1694	1.5%
porto alegre	1600	1.4%
salvador	1445	1.3%
guarulhos	1351	1.2%
sao bernardo do campo	1084	1.0%
Other values (4063)	73688	64.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	24275	12.1%
paulo	18084	9.0%
de	11072	5.5%
rio	9469	4.7%
janeiro	7873	3.9%
do	4921	2.5%
belo	3232	1.6%
horizonte	3187	1.6%
brasilia	2410	1.2%
porto	1904	1.0%
Other values (3256)	113541	56.8%

Most occurring characters

Value	Count	Frequency (%)
a	194510	16.5%
o	145414	12.3%
i	90118	7.6%
r	87313	7.4%
	85895	7.3%
e	76427	6.5%
s	72306	6.1%
n	52274	4.4%
u	51736	4.4%
l	51391	4.4%
Other values (21)	271502	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1092452	92.7%
Space Separator	85895	7.3%
Dash Punctuation	280	< 0.1%
Other Punctuation	257	< 0.1%
Decimal Number	2	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	194510	17.8%
o	145414	13.3%
i	90118	8.2%
r	87313	8.0%
e	76427	7.0%
s	72306	6.6%
n	52274	4.8%
u	51736	4.7%
l	51391	4.7%
p	42919	3.9%
Other values (16)	228044	20.9%

Value	Count	Frequency (%)
1	1	50.0%
4	1	50.0%

Value	Count	Frequency (%)
	85895	100.0%

Value	Count	Frequency (%)
-	280	100.0%

Value	Count	Frequency (%)
'	257	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1092452	92.7%
Common	86434	7.3%

Most frequent character per script

Value	Count	Frequency (%)
a	194510	17.8%
o	145414	13.3%
i	90118	8.2%
r	87313	8.0%
e	76427	7.0%
s	72306	6.6%
n	52274	4.8%
u	51736	4.7%
l	51391	4.7%
p	42919	3.9%
Other values (16)	228044	20.9%

Value	Count	Frequency (%)
	85895	99.4%
-	280	0.3%
'	257	0.3%
1	1	< 0.1%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1178886	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	194510	16.5%
o	145414	12.3%
i	90118	7.6%
r	87313	7.4%
	85895	7.3%
e	76427	6.5%
s	72306	6.1%
n	52274	4.4%
u	51736	4.4%
l	51391	4.4%
Other values (21)	271502	23.0%

estado_consumidor
Categorical

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

SP	48121
RJ	14739
MG	13312
RS	6332
PR	5816
Other values (22)	25753

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	228146
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	SP
5th row	SP

Value	Count	Frequency (%)
SP	48121	42.2%
RJ	14739	12.9%
MG	13312	11.7%
RS	6332	5.6%
PR	5816	5.1%
SC	4178	3.7%
BA	3879	3.4%
DF	2415	2.1%
GO	2340	2.1%
ES	2299	2.0%
Other values (17)	10642	9.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	48121	42.2%
rj	14739	12.9%
mg	13312	11.7%
rs	6332	5.6%
pr	5816	5.1%
sc	4178	3.7%
ba	3879	3.4%
df	2415	2.1%
go	2340	2.1%
es	2299	2.0%
Other values (17)	10642	9.3%

Most occurring characters

Value	Count	Frequency (%)
S	62153	27.2%
P	58079	25.5%
R	27807	12.2%
M	16202	7.1%
G	15652	6.9%
J	14739	6.5%
A	6555	2.9%
E	5988	2.6%
C	5757	2.5%
B	4494	2.0%
Other values (7)	10720	4.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	228146	100.0%

Most frequent character per category

Value	Count	Frequency (%)
S	62153	27.2%
P	58079	25.5%
R	27807	12.2%
M	16202	7.1%
G	15652	6.9%
J	14739	6.5%
A	6555	2.9%
E	5988	2.6%
C	5757	2.5%
B	4494	2.0%
Other values (7)	10720	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	228146	100.0%

Most frequent character per script

Value	Count	Frequency (%)
S	62153	27.2%
P	58079	25.5%
R	27807	12.2%
M	16202	7.1%
G	15652	6.9%
J	14739	6.5%
A	6555	2.9%
E	5988	2.6%
C	5757	2.5%
B	4494	2.0%
Other values (7)	10720	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	228146	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	62153	27.2%
P	58079	25.5%
R	27807	12.2%
M	16202	7.1%
G	15652	6.9%
J	14739	6.5%
A	6555	2.9%
E	5988	2.6%
C	5757	2.5%
B	4494	2.0%
Other values (7)	10720	4.7%

cep_vendedor
Real number (ℝ_≥0)

Distinct	2136
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	24512.57625
Minimum	1001
Maximum	99730
Zeros	0
Zeros (%)	0.0%
Memory size	891.3 KiB

Quantile statistics

Minimum	1001
5-th percentile	2972
Q1	6429
median	13660
Q3	28470
95-th percentile	88344
Maximum	99730
Range	98729
Interquartile range (IQR)	22041

Descriptive statistics

Standard deviation	27636.88629
Coefficient of variation (CV)	1.127457433
Kurtosis	0.9085554207
Mean	24512.57625
Median Absolute Deviation (MAD)	8130
Skewness	1.548794148
Sum	2796223110
Variance	763797483.7
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14940	8192	7.2%
5849	2108	1.8%
15025	2092	1.8%
9015	1837	1.6%
13405	1667	1.5%
8577	1545	1.4%
4782	1520	1.3%
3204	1468	1.3%
4160	1249	1.1%
13232	1238	1.1%
Other values (2126)	91157	79.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1001	22	< 0.1%
1021	41	< 0.1%
1022	5	< 0.1%
1023	5	< 0.1%
1026	297	0.3%

Value	Count	Frequency (%)
99730	12	< 0.1%
99700	2	< 0.1%
99670	1	< 0.1%
99500	61	0.1%
99300	2	< 0.1%

cidade_vendedor
Categorical

HIGH CARDINALITY

Distinct	588
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

sao paulo	28427
ibitinga	8192
curitiba	3067
santo andre	3065
sao jose do rio preto	2650
Other values (583)	68672

Length

Max length	40
Median length	9
Mean length	10.10123342
Min length	2

Characters and Unicode

Total characters	1152278
Distinct characters	36
Distinct categories	8 ?
Distinct scripts	3 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	60 ?
Unique (%)	0.1%

Sample

1st row	maua
2nd row	maua
3rd row	maua
4th row	maua
5th row	maua

Value	Count	Frequency (%)
sao paulo	28427	24.9%
ibitinga	8192	7.2%
curitiba	3067	2.7%
santo andre	3065	2.7%
sao jose do rio preto	2650	2.3%
belo horizonte	2535	2.2%
rio de janeiro	2379	2.1%
ribeirao preto	2280	2.0%
maringa	2263	2.0%
guarulhos	2027	1.8%
Other values (578)	57188	50.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	35332	18.0%
paulo	28705	14.6%
ibitinga	8192	4.2%
rio	5711	2.9%
do	5375	2.7%
preto	5353	2.7%
jose	3990	2.0%
de	3900	2.0%
santo	3181	1.6%
andre	3080	1.6%
Other values (618)	93309	47.6%

Most occurring characters

Value	Count	Frequency (%)
a	191731	16.6%
o	140995	12.2%
i	98817	8.6%
	82115	7.1%
r	74930	6.5%
s	73375	6.4%
e	61820	5.4%
u	60353	5.2%
p	56645	4.9%
l	54779	4.8%
Other values (26)	256718	22.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1068969	92.8%
Space Separator	82115	7.1%
Other Punctuation	607	0.1%
Modifier Symbol	366	< 0.1%
Dash Punctuation	161	< 0.1%
Open Punctuation	29	< 0.1%
Close Punctuation	29	< 0.1%
Nonspacing Mark	2	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	191731	17.9%
o	140995	13.2%
i	98817	9.2%
r	74930	7.0%
s	73375	6.9%
e	61820	5.8%
u	60353	5.6%
p	56645	5.3%
l	54779	5.1%
t	45896	4.3%
Other values (14)	209628	19.6%

Value	Count	Frequency (%)
'	343	56.5%
/	138	22.7%
.	76	12.5%
@	38	6.3%
,	6	1.0%
\	6	1.0%

Value	Count	Frequency (%)
	82115	100.0%

Value	Count	Frequency (%)
´	366	100.0%

Value	Count	Frequency (%)
-	161	100.0%

Value	Count	Frequency (%)
(	29	100.0%

Value	Count	Frequency (%)
)	29	100.0%

Value	Count	Frequency (%)
̃	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1068969	92.8%
Common	83307	7.2%
Inherited	2	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
a	191731	17.9%
o	140995	13.2%
i	98817	9.2%
r	74930	7.0%
s	73375	6.9%
e	61820	5.8%
u	60353	5.6%
p	56645	5.3%
l	54779	5.1%
t	45896	4.3%
Other values (14)	209628	19.6%

Value	Count	Frequency (%)
	82115	98.6%
´	366	0.4%
'	343	0.4%
-	161	0.2%
/	138	0.2%
.	76	0.1%
@	38	< 0.1%
(	29	< 0.1%
)	29	< 0.1%
,	6	< 0.1%

Value	Count	Frequency (%)
̃	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1151910	> 99.9%
None	366	< 0.1%
Diacriticals	2	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
a	191731	16.6%
o	140995	12.2%
i	98817	8.6%
	82115	7.1%
r	74930	6.5%
s	73375	6.4%
e	61820	5.4%
u	60353	5.2%
p	56645	4.9%
l	54779	4.8%
Other values (24)	256350	22.3%

Value	Count	Frequency (%)
´	366	100.0%

Value	Count	Frequency (%)
̃	2	100.0%

estado_vendedor
Categorical

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	891.3 KiB

SP	81373
MG	8866
PR	8812
RJ	4817
SC	4174
Other values (17)	6031

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	228146
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	SP
5th row	SP

Value	Count	Frequency (%)
SP	81373	71.3%
MG	8866	7.8%
PR	8812	7.7%
RJ	4817	4.2%
SC	4174	3.7%
RS	2214	1.9%
DF	921	0.8%
BA	681	0.6%
GO	528	0.5%
PE	462	0.4%
Other values (12)	1225	1.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	81373	71.3%
mg	8866	7.8%
pr	8812	7.7%
rj	4817	4.2%
sc	4174	3.7%
rs	2214	1.9%
df	921	0.8%
ba	681	0.6%
go	528	0.5%
pe	462	0.4%
Other values (12)	1225	1.1%

Most occurring characters

Value	Count	Frequency (%)
P	90706	39.8%
S	88202	38.7%
R	15913	7.0%
M	9482	4.2%
G	9394	4.1%
J	4817	2.1%
C	4273	1.9%
A	1099	0.5%
E	942	0.4%
D	921	0.4%
Other values (6)	2397	1.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	228146	100.0%

Most frequent character per category

Value	Count	Frequency (%)
P	90706	39.8%
S	88202	38.7%
R	15913	7.0%
M	9482	4.2%
G	9394	4.1%
J	4817	2.1%
C	4273	1.9%
A	1099	0.5%
E	942	0.4%
D	921	0.4%
Other values (6)	2397	1.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	228146	100.0%

Most frequent character per script

Value	Count	Frequency (%)
P	90706	39.8%
S	88202	38.7%
R	15913	7.0%
M	9482	4.2%
G	9394	4.1%
J	4817	2.1%
C	4273	1.9%
A	1099	0.5%
E	942	0.4%
D	921	0.4%
Other values (6)	2397	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	228146	100.0%

Most frequent character per block

Value	Count	Frequency (%)
P	90706	39.8%
S	88202	38.7%
R	15913	7.0%
M	9482	4.2%
G	9394	4.1%
J	4817	2.1%
C	4273	1.9%
A	1099	0.5%
E	942	0.4%
D	921	0.4%
Other values (6)	2397	1.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id_pedido	id_consumidor	status_da_ordem	horario_pedido	pedido_aprovado	pedido_com_entregador	pedido_entregue	data_estimada	item_id	produto_id	vendedor_id	data_limite_envio	preco	frete	pagamento_sequencial	tipo_pagamento	prestacoes	valor_pagamento	id_review	review_score	titulo_review	comentario_review	data_criacao_review	data_resposta_review	categoria_produto	qtd_fotos_produto	peso_produto	comprimento_produto	altura_produto	largura_produto	id_unico_consumidor	cep_consumidor	cidade_consumidor	estado_consumidor	cep_vendedor	cidade_vendedor	estado_vendedor
0	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	1.0	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	1.0	credit_card	1.0	18.12	a54f0611adc9ed256b57ede6b6eb5114	4	NaN	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.	2017-10-11 00:00:00	2017-10-12 03:43:48	utilidades_domesticas	4.0	500.0	19.0	8.0	13.0	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	9350.0	maua	SP
1	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	1.0	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	3.0	voucher	1.0	2.00	a54f0611adc9ed256b57ede6b6eb5114	4	NaN	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.	2017-10-11 00:00:00	2017-10-12 03:43:48	utilidades_domesticas	4.0	500.0	19.0	8.0	13.0	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	9350.0	maua	SP
2	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	1.0	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	2.0	voucher	1.0	18.59	a54f0611adc9ed256b57ede6b6eb5114	4	NaN	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.	2017-10-11 00:00:00	2017-10-12 03:43:48	utilidades_domesticas	4.0	500.0	19.0	8.0	13.0	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	9350.0	maua	SP
3	128e10d95713541c87cd1a2e48201934	a20e8105f23924cd00833fd87daa0831	delivered	2017-08-15 18:29:31	2017-08-15 20:05:16	2017-08-17 15:28:33	2017-08-18 14:44:43	2017-08-28 00:00:00	1.0	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-21 20:05:16	29.99	7.78	1.0	credit_card	3.0	37.77	b46f1e34512b0f4c74a72398b03ca788	4	NaN	Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente.	2017-08-19 00:00:00	2017-08-20 15:16:36	utilidades_domesticas	4.0	500.0	19.0	8.0	13.0	3a51803cc0d012c3b5dc8b7528cb05f7	3366	sao paulo	SP	9350.0	maua	SP
4	0e7e841ddf8f8f2de2bad69267ecfbcf	26c7ac168e1433912a51b924fbd34d34	delivered	2017-08-02 18:24:47	2017-08-02 18:43:15	2017-08-04 17:35:43	2017-08-07 18:30:01	2017-08-15 00:00:00	1.0	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-08 18:37:31	29.99	7.78	1.0	credit_card	1.0	37.77	dc90f19c2806f1abba9e72ad3c350073	5	NaN	Só achei ela pequena pra seis xícaras ,mais é um bom produto\r\n	2017-08-08 00:00:00	2017-08-08 23:26:23	utilidades_domesticas	4.0	500.0	19.0	8.0	13.0	ef0996a1a279c26e7ecbd737be23d235	2290	sao paulo	SP	9350.0	maua	SP
5	bfc39df4f36c3693ff3b63fcbea9e90a	53904ddbea91e1e92b2b3f1d09a7af86	delivered	2017-10-23 23:26:46	2017-10-25 02:14:11	2017-10-27 16:48:46	2017-11-07 18:04:59	2017-11-13 00:00:00	1.0	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-31 02:14:11	29.99	14.10	1.0	boleto	1.0	44.09	1bafb430e498b939f258b9c9dbdff9b1	3	NaN	NaN	2017-11-08 00:00:00	2017-11-10 19:52:38	utilidades_domesticas	4.0	500.0	19.0	8.0	13.0	e781fdcc107d13d865fc7698711cc572	88032	florianopolis	SC	9350.0	maua	SP
6	8736140c61ea584cb4250074756d8f3b	ab8844663ae049fda8baf15fc928f47f	delivered	2017-08-10 13:35:55	2017-08-10 13:50:09	2017-08-11 13:52:35	2017-08-16 19:03:36	2017-08-23 00:00:00	1.0	b00a32a0b42fd65efb58a5822009f629	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-16 13:50:09	75.90	7.79	1.0	credit_card	1.0	83.69	b8238c6515192f8129081e17dc57d169	5	NaN	custo beneficio, simples de usar e rápido	2017-08-17 00:00:00	2017-08-21 12:43:27	bebes	3.0	238.0	20.0	10.0	15.0	02c9e0c05a817d4562ec0e8c90f29dba	8577	itaquaquecetuba	SP	9350.0	maua	SP
7	88407c8c6e12493ff6e845df39540112	e902cb9d9992a69a267f69dec57aa3a3	delivered	2017-08-15 02:03:01	2017-08-15 02:15:13	2017-08-16 15:52:29	2017-08-25 21:59:26	2017-08-28 00:00:00	1.0	b00a32a0b42fd65efb58a5822009f629	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-21 02:15:13	75.90	7.79	1.0	credit_card	2.0	83.69	186b702b3817fd5cc00b201b11764d63	4	NaN	muitro bom o produto chegou dentro do prazo.	2017-08-26 00:00:00	2017-08-28 20:10:38	bebes	3.0	238.0	20.0	10.0	15.0	28adbfbaf0b9c5e5a0555a8c853a7534	13060	campinas	SP	9350.0	maua	SP
8	4f2acff0b7d2bcc4a408abe5a223d407	d67b6cca5a87299f711a6961f579fe67	delivered	2017-08-01 16:31:35	2017-08-02 02:50:25	2017-08-03 14:36:34	2017-08-09 19:56:50	2017-08-23 00:00:00	1.0	b00a32a0b42fd65efb58a5822009f629	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-08 02:50:25	75.90	14.28	1.0	boleto	1.0	90.18	567900cb1263f2ee7341989937a789cc	5	NaN	NaN	2017-08-10 00:00:00	2017-08-11 21:08:38	bebes	3.0	238.0	20.0	10.0	15.0	aea90564d6f09ae11bf936f55ed49d72	82030	curitiba	PR	9350.0	maua	SP
9	019aaee09698daf81dcffe9d94a18b5c	e3893e579755de4feb1a4d0313c103fa	delivered	2017-08-10 14:04:58	2017-08-10 14:23:38	2017-08-11 13:52:35	2017-08-12 11:56:49	2017-08-23 00:00:00	1.0	b00a32a0b42fd65efb58a5822009f629	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-16 14:23:38	75.90	7.79	1.0	credit_card	2.0	83.69	43334848a48a7abf6faa2f8aba675b8a	2	NaN	tudo correu bem com a loja e com a entrega mas o produto não funcionou, vou devolver	2017-08-13 00:00:00	2017-08-14 12:24:58	bebes	3.0	238.0	20.0	10.0	15.0	cd6b577df45c00daa6b2767eaa947c72	13092	campinas	SP	9350.0	maua	SP

Last rows

	id_pedido	id_consumidor	status_da_ordem	horario_pedido	pedido_aprovado	pedido_com_entregador	pedido_entregue	data_estimada	item_id	produto_id	vendedor_id	data_limite_envio	preco	frete	pagamento_sequencial	tipo_pagamento	prestacoes	valor_pagamento	id_review	review_score	titulo_review	comentario_review	data_criacao_review	data_resposta_review	categoria_produto	qtd_fotos_produto	peso_produto	comprimento_produto	altura_produto	largura_produto	id_unico_consumidor	cep_consumidor	cidade_consumidor	estado_consumidor	cep_vendedor	cidade_vendedor	estado_vendedor
114063	8c1d27c10cc60cc369a428813bb71350	18138351c3724e32f1d6e0268f0c7663	delivered	2018-07-25 16:18:46	2018-07-25 16:30:20	2018-07-26 14:31:00	2018-07-30 19:42:42	2018-08-13 00:00:00	1.0	9680a78df870a1cb6ae00cb3436fe06a	a72f15980dc3e9bfd1a49ac9b2f3af65	2018-07-31 16:30:20	89.90	18.73	1.0	credit_card	1.0	108.63	f67e51de7cb2234e049746605fac5e45	4	recomendo	otimo produto	2018-07-31 00:00:00	2018-08-08 04:46:21	moveis_decoracao	2.0	450.0	16.0	16.0	16.0	e0333f86b92d8d0de733c3eceed649ce	38181	araxa	MG	17512.0	marilia	SP
114064	39e89b39b5cc8b5e3a38f23e915d1823	2b91bc260dcffbdacd12c4b09e5c7463	delivered	2017-07-24 11:29:43	2017-07-24 11:43:21	2017-07-24 22:34:38	2017-08-10 19:42:10	2017-08-23 00:00:00	1.0	24fcd474105d95d2002f38f0cacf87ee	72c73be2b085b9d57650dd53eb2004c9	2017-07-28 11:43:21	29.40	17.92	1.0	credit_card	4.0	47.32	e6de6c25dc2f6e602c1227e20756c992	5	NaN	NaN	2017-08-11 00:00:00	2017-08-16 14:34:55	automotivo	1.0	700.0	16.0	7.0	11.0	bd0a735ae91504c00c71638c720e3cca	45051	vitoria da conquista	BA	2116.0	sao paulo	SP
114065	fbff77db5421bb7e1da292db45d07e75	7795e3faa6e16fc40aafee568b25a85d	delivered	2017-03-15 11:41:46	2017-03-15 11:41:46	2017-03-16 04:19:03	2017-03-20 10:34:54	2017-04-03 00:00:00	1.0	654ccc4e5459e7ba6b8d9fb04c45b9db	2d8cfba3fcd3170555941605edaa196a	2017-03-21 11:41:46	45.00	10.96	1.0	credit_card	1.0	8.25	c13d0d31c88734e32cd3067bf14d34d7	5	NaN	NaN	2017-03-21 00:00:00	2017-03-23 00:59:49	livros_tecnicos	1.0	300.0	28.0	2.0	18.0	6ee4fdb7edab032aaa8392bab5446546	9060	santo andre	SP	6080.0	osasco	SP
114066	fbff77db5421bb7e1da292db45d07e75	7795e3faa6e16fc40aafee568b25a85d	delivered	2017-03-15 11:41:46	2017-03-15 11:41:46	2017-03-16 04:19:03	2017-03-20 10:34:54	2017-04-03 00:00:00	1.0	654ccc4e5459e7ba6b8d9fb04c45b9db	2d8cfba3fcd3170555941605edaa196a	2017-03-21 11:41:46	45.00	10.96	2.0	voucher	1.0	47.71	c13d0d31c88734e32cd3067bf14d34d7	5	NaN	NaN	2017-03-21 00:00:00	2017-03-23 00:59:49	livros_tecnicos	1.0	300.0	28.0	2.0	18.0	6ee4fdb7edab032aaa8392bab5446546	9060	santo andre	SP	6080.0	osasco	SP
114067	5bacbd9f42bd029c3a296501224e193e	5a1470d43d8ad960d4199134d3df48e0	delivered	2018-08-10 21:14:35	2018-08-10 21:25:22	2018-08-13 13:54:00	2018-08-21 04:16:31	2018-08-30 00:00:00	1.0	710e8b076db06c8e5343a9e23f0e3d83	8dd386be0767c330276ea6a3f96532d3	2018-08-15 21:25:22	44.99	22.25	1.0	credit_card	2.0	134.48	f91f12b20162095a387a237e114e7d67	5	NaN	NaN	2018-08-21 00:00:00	2018-08-21 22:01:55	esporte_lazer	2.0	600.0	30.0	20.0	20.0	0b39f417a3c099ff0497346258e8d752	39810	carai	MG	88490.0	paulo lopes	SC
114068	5bacbd9f42bd029c3a296501224e193e	5a1470d43d8ad960d4199134d3df48e0	delivered	2018-08-10 21:14:35	2018-08-10 21:25:22	2018-08-13 13:54:00	2018-08-21 04:16:31	2018-08-30 00:00:00	2.0	710e8b076db06c8e5343a9e23f0e3d83	8dd386be0767c330276ea6a3f96532d3	2018-08-15 21:25:22	44.99	22.25	1.0	credit_card	2.0	134.48	f91f12b20162095a387a237e114e7d67	5	NaN	NaN	2018-08-21 00:00:00	2018-08-21 22:01:55	esporte_lazer	2.0	600.0	30.0	20.0	20.0	0b39f417a3c099ff0497346258e8d752	39810	carai	MG	88490.0	paulo lopes	SC
114069	1ab38815794efa43d269d62b98dae815	a0b67404d84a70ef420a7f99ad6b190a	delivered	2018-07-01 10:23:10	2018-07-05 16:17:52	2018-07-04 14:34:00	2018-07-09 15:06:57	2018-07-20 00:00:00	1.0	31ec3a565e06de4bdf9d2a511b822b4d	babcc0ab201e4c60188427cae51a5b8b	2018-07-10 08:32:33	79.00	14.13	1.0	boleto	1.0	93.13	7f9849fcbfdf9fa3070c05b5501bf066	5	NaN	NaN	2018-07-10 00:00:00	2018-07-10 18:32:29	construcao_ferramentas_iluminacao	2.0	750.0	30.0	28.0	28.0	2077f7ec37df79c62cc24b7b8f30e8c9	8528	ferraz de vasconcelos	SP	13660.0	porto ferreira	SP
114070	735dce2d574afe8eb87e80a3d6229c48	d531d01affc2c55769f6b9ed410d8d3c	delivered	2018-07-24 09:46:27	2018-07-24 11:24:27	2018-07-24 15:14:00	2018-08-02 22:47:35	2018-08-16 00:00:00	1.0	1d187e8e7a30417fda31e85679d96f0f	d263fa444c1504a75cbca5cc465f592a	2018-07-30 11:24:27	399.00	45.07	1.0	debit_card	1.0	444.07	19f21ead7ffe5b1b5147a7877c22bae5	5	NaN	NaN	2018-08-03 00:00:00	2018-08-04 11:22:40	moveis_decoracao	2.0	2100.0	80.0	8.0	30.0	8cf3c6e1d2c8afaab2eda3fa01d4e3d2	60455	fortaleza	CE	13478.0	americana	SP
114071	25d2bfa43663a23586afd12f15b542e7	9d8c06734fde9823ace11a4b5929b5a7	delivered	2018-05-22 21:13:21	2018-05-22 21:35:40	2018-05-24 12:28:00	2018-06-12 23:11:29	2018-06-08 00:00:00	1.0	6e1c2008dea1929b9b6c27fa01381e90	edf3fabebcc20f7463cc9c53da932ea8	2018-05-28 21:31:24	219.90	24.12	1.0	credit_card	4.0	244.02	ec2817e750153dfdd61894780dfc5d9e	4	NaN	NaN	2018-06-10 00:00:00	2018-06-13 09:17:47	moveis_decoracao	1.0	5900.0	41.0	21.0	41.0	e55e436481078787e32349cee9febf5e	39803	teofilo otoni	MG	8320.0	sao paulo	SP
114072	1565f22aa9452ff278638e87cc895678	56772dfbcbe7df908a284ff0d53adf7d	delivered	2018-05-15 17:41:00	2018-05-16 03:35:29	2018-05-16 17:20:00	2018-05-21 14:31:41	2018-05-29 00:00:00	1.0	9c1e194db1d35a79d962ea610bfe0868	f3862c2188522d89860c38a3ea8b550d	2018-05-22 03:35:29	15.50	12.79	1.0	boleto	1.0	28.29	cbb879403973e209b4df371a5dafbaa7	5	NaN	NaN	2018-06-01 00:00:00	2018-06-01 15:14:23	perfumaria	1.0	83.0	17.0	8.0	13.0	6ceea7c1088e15ab3c67980a2d9bb309	9687	sao bernardo do campo	SP	14092.0	ribeirao preto	SP

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters